PART III - NUMBER TO WORD - (N2WE)

Before I proceed to part III, I would like to answer a few questions that I received from the posers.

1.         How can the N2WE Converter be of  use to its user?

            N2WE Converter can be used as an add-in to an excel worksheet with a custom made worksheet function (Customized formulas) specially to carry out the task of converting numerical values for currency (Ringgit) into words.

For an example,  to fill in a space required for numbers to be written in word on bank’s cheque, receipt issuance, Payment Vouchers, Payslip, invoices and many other document the require number to be written in words.

It works very swiftly and save you from making typos.

            It can also work as an open or stand alone file or a sheet in a file and still retain the capability to function as converter.

2.         Is the converter free?

            The knowledge is free but you have to buy a legal copy of your MS Office with MS Excel in order to make use of the converter. The converter is made for MS excel or any compatible worksheet such as open office etc.

3.         “Boleh kamek makey tok pakey kamek academic project kah J?

            Suka ati kitak empun, kitak nak polah apa dengannya asal jangan membabit saya kalau kitak kenak tangkap oleh dekan, pensyarah atau project co-cordinator kitak memplagiar.

PART III

For this part, we will be referring to the table of number 0-19, and write the word to the number below

We will concentrate on the double or two digit number from number 10-19. The one digit is straight forward. Note that the illustration only concentrate to illustrate the number in the form listed in the table although other expression in other combination are also mention just to help readers to understand the language structure involved.

The table is caption as “ID”, “NUMBER IN QUESTION” , “UNIT” , “TENTH” , “HUNDREDTH” , “NO OF DIGIT” , “COMMENTS”

The “ID” is only used as a reference and will not be used in the programming. In data base it is always a good habit to put “”ID” field or column so that you can easily refer to the so many lines of rows. It is more meaningful to have the ID number on each rows unique to each other just like our NRID or IC number. If there are 50,000 people in Malaysia having the same name, their IC number will not be the same unless someone faked it. Same thing happen with out bank account number. The account holder’s name maybe the same but the account number is unique to everyone else. Normally the ID is arranged in ascending order ie arranged from the smallest to the biggest down the rows or in database rows is referred to as “Record”. The column is called “Field”.  In excel it is referred to as column and row.

NUMBER IN QUESTION” – This is the number that we talk about.

“TENTH” – Refer to number with two digit number

“HUNDREDTH” – Refer to number with three digit number

“NO OF DIGIT”  - The number of digit the number have

“COMMENTS” – Helps you to understand the number referred to in the “number in question” column although it may also help to confuse you.

I may use different terms to describe certain object.  I am also discovering and learning how to describe them in the laymen’s term so that you can understand the explanation well. For example  the term Read. In other instances I may use the word expression. If I use the word expression (the term used in programming) in the very first part of this topic it may take you some time to configure its meaning. So I use both and they refer to the same thing.

For the purpose of the programming part, we will only deal with positive number. That is number that is equal to and more than zero ( ie From 0,1,2….. till the zillion) We will not be dealing with negative number such as  -0.123, -1, -2, -3…till the negative zillion. We will not deal with negative number in this programming illustration.

Value ie Number is intended to be read as currency, either as Ringgit, Rupiah, Rupee or Dollar and so forth.

Number or value will also involve fraction contrary to what I said earlier as “INTEGER” (whole number) only. The reason why I say so was because when it come to the reading or expressing in word, the value in it currency form, any thing after the decimal will also be read  in a similar manner it is read before the decimal.  Eg  2125.28, The 2125 is read as though it is INTEGER when in reality the whole number  ie 2125.28 is not an integer.  The number after the decimal ie 28 is also read as Integer.  Let me read it for you the number “2125.28” – Read as (A)  Two Thousand one hundred Twenty Five  (B) [and sen] Twenty Eight [Only]. Notice that how the number are read? It is read saperately as if there are two saperate INTEGER, one before and the other after the decimal. ie 2125 and 28.  BTW an interger is a whole Number (without fraction ie  without anything after the decimal  eg .28 (point two eight)

For the purpose of our illustration we will the the UK English spelling. The American spelling differ slightly eg  Fourty and Forty. We will not provide the option of UK English or American English. This illustration have no language option other than UK English.

The topic that we deal with is no new thing in our everyday life. We use to read and express numbers every day and we learn and know how to read and write at a tender age of  five or even younger.  This topic serve to explain how number that we write and express in our daily life is goinging to be communicated to our computer so that it can output number into word the way the computer hardware and software understood it ie away from the way we are train to read or write it. But again the software and the computer is no match to our brain as it can adapt to many different denomination or bases on how numbers are expressed.

In the next part we will go through briefly the Malay and Miriek language structure. It will be quick as you have understood (or completely confused – Sory if that’s the case) the English Language structure. The malay and Miriek is not having the same structure as the English language. So we will capitalize of the difference and that will be fast to do.

ENGLISH
ID	NUMBER IN QUESTION	UNIT	TENTH	HUNDREDTH	NO OF DIGIT	COMMENTS
1	0	Zero			1	Read as "zero" and will not be read as "zero" again for number more than zero, In two and three digit it is read as "hundred", "thousand" ….
2	1	One			1	As singile digit, read as "one" but in double digit it is read either as "teen" and "ten" or "eleven". "ty"as in 20, 30
3	2	Two			1	As singile digit, read as "two" but also read as "twent", forget the "second" for the time being, its not relevant in this illustration
4	3	Three			1	As single digit, read as "three" but read "thir" in 2 digit as well as read as "three" as in 23 -> twenty "three"
5	4	Four			1	As singile digit, read as "four" and maintain no matter how many digit a number are except for the spelling "For or Four" but NP
6	5	Five			1	As singile digit, read as "five" but read differently when it is in 2 digit with combination of number eg "Fif" instead on five
7	6	Six			1	As singile digit, read as "six" and maintain no matter how many digit a number are.
8	7	Seven			1	As singile digit, read as "seven" and maintain no matter how many digit a number are.
9	8	Eight			1	As singile digit, read as "eight" and maintain no matter how many digit a number are.
10	9	Nine			1	As singile digit, read as "nine" and maintain no matter how many digit a number are.
11	10	Ten			2	Read as "ten". When it is written it is expressed as "one" and a "zero", If there is additional zero behind it, it will be read as hundred, thousand, million, billion, trillion etc
12	11	Eleven			2	Read as "eleven" but written as "one" and "one", It will recur again as 11 hundred (read in American English, but in this illustration, this is irrelavent), 11 thousand, 11 million, 11 billion etc
13	12	Twelve			2	Read as "Twelve" (at least some similarity), but written as "one"and "Two", the is no other way this arrangement of combination of 2 digit number is expressed. It will reapeat as 12 thousand, 12 million, 12 billion, 12 trillion, 12 zillion and so forth
14	13	Thir	teen		2	Read as "Thir-teen" (at least some similarity "Thir), but written as "one"and "three" and a "teen" Don't worry!! It'll be easier sooner, also read in the reverse. You can split it into 2 object ie "Thir" and "teen" if you want to or take it as a single object. It will be read as "Thirteen" as single object and read as "Thir & teen" and two object. It will repeat itself through 13 thousand, 13, million, 13 billion and so forth. NOTE : (1) For two digit number, ie 13 to 19, the number 13 is the start of the "Teen" (2) Look at how the number is read. The "Thir" came after the "teen" ie it read in reverse order instead of "teen" "Thir" and this reverse expression will go on until digit number 19. Noticegoing to be read or expressed will make some difference that when in "130" it will be expressed or read as "Thirty instead of Thirteen", Anything other than 13-19 expression will not follow the same rule applicable to number 13-19.
15	14	Four	teen		2	Read as "Four" and will be constantly expressed or read as "Four" no matter in how many digit or combination it appear in. In two digit number it it read or expressed as "Four" and "Teen". Notice that it is read in the reverse order. The "Four" is expressed first and then the "teen" as in any other number in the teen ie two digit number from 13 to 19. It will repeat itself through 13 "Thousand", million, billion and so forth. Note : American and English Spelling differs, "For" and "Four". In our illustration we will be using the UK English spelling and will not be optional. You can do it if you want to but for this illustration the option will not be included.
16	15	Fif	teen		2	Read as "Fif" instead of "five" with "teen",  but written as "one"and "five" Again it is read in the reverse ie "Fif" then the "teen", Read in this combination and arrangement it (15) will repeat itself through 15 thousand, million, billion and so forth.  In this illustration you can take this two digit number in this order of arrangement as "Fif" and "teen" ie. as two object or as "Fifteen" as one object. For our illustration I will take it as one single object ie, as "Fifteen".
17	16	Six	teen		2	Read or expressed as "six" constantly in what ever combination and arrangement order, ending with "teen" , but written as "one"and "six" Notice that it is read in the reverse again. 16 with reapeat itself through 16 to thousand, million, billion and so forth.
18	17	Seven	teen		2	Read or expressed as "seven" constantly in what ever combination and arrangement order, ending with "teen" , but written as "one"and "seven" Notice that it is read in the reverse again. 17 with reapeat itself through 16 to thousand, million, billion and so forth.
19	18	Eight	Teen		2	Read or expressed as "eight" constantly in what ever combination and arrangement order, ending with "teen" , but written as "one"and "eight" Notice that it is read in the reverse again. 18 with reapeat itself through 18 to thousand, million, billion and so forth.
20	19	Nine	Teen		2	Read or expressed as "nine" constantly in what ever combination and arrangement order, ending with "teen" , but written as "one"and nine" Notice that it is read in the reverse again. 19 with reapeat itself through 19 to thousand, million, billion and so forth.

Will be continued and have a nice time.