| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert numbers to words
Hi all,
simple question, how to convert number to words. ex. $ 10,000 == ten thousand dollars thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert numbers to words
hi
see this site.... http://support.microsoft.com/?kbid=213360 and this site.... http://www.sulprobil.com/html/spellnumber.html and this site.... http://www.ozgrid.com/VBA/ValueToWords.htm yeah....it can get complicated. good luck. regard FSt1 "reza" wrote: Hi all, simple question, how to convert number to words. ex. $ 10,000 == ten thousand dollars thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert numbers to words
FSt1...
Thanks "FSt1" wrote: hi see this site.... http://support.microsoft.com/?kbid=213360 and this site.... http://www.sulprobil.com/html/spellnumber.html and this site.... http://www.ozgrid.com/VBA/ValueToWords.htm yeah....it can get complicated. good luck. regard FSt1 "reza" wrote: Hi all, simple question, how to convert number to words. ex. $ 10,000 == ten thousand dollars thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert numbers to words
I used the Reza site to get the formula to insert into my form. We are
making a check form that will pull the number from one portion of the check & convert it into a written out dollar amount. The pertinent "pull from" cell is C4. I've inserted the formula shown below into my form in the appropriate location. =SpellNumber(C4) I had previously formatted the cell for "text." Now it only shows the formula typed out. What do I need to format the cell as in order to get words? (i.e. Thirty-two dollars and fifteen cents, etc.) Thanks for your help! "FSt1" wrote: hi see this site.... http://support.microsoft.com/?kbid=213360 and this site.... http://www.sulprobil.com/html/spellnumber.html and this site.... http://www.ozgrid.com/VBA/ValueToWords.htm yeah....it can get complicated. good luck. regard FSt1 "reza" wrote: Hi all, simple question, how to convert number to words. ex. $ 10,000 == ten thousand dollars thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert numbers to words
Your mistake is in formatting the cell as text. Format as General or
Number, then re-enter the formula. I hope that you did remember to install the UDF for SpellNumber? -- David Biddulph "LeighH" wrote in message ... I used the Reza site to get the formula to insert into my form. We are making a check form that will pull the number from one portion of the check & convert it into a written out dollar amount. The pertinent "pull from" cell is C4. I've inserted the formula shown below into my form in the appropriate location. =SpellNumber(C4) I had previously formatted the cell for "text." Now it only shows the formula typed out. What do I need to format the cell as in order to get words? (i.e. Thirty-two dollars and fifteen cents, etc.) Thanks for your help! "FSt1" wrote: hi see this site.... http://support.microsoft.com/?kbid=213360 and this site.... http://www.sulprobil.com/html/spellnumber.html and this site.... http://www.ozgrid.com/VBA/ValueToWords.htm yeah....it can get complicated. good luck. regard FSt1 "reza" wrote: Hi all, simple question, how to convert number to words. ex. $ 10,000 == ten thousand dollars thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| numbers convert into words | Excel Discussion (Misc queries) | |||
| numbers convert into words | Excel Discussion (Misc queries) | |||
| Convert numbers to words | Excel Worksheet Functions | |||
| how to convert numbers into words | Excel Worksheet Functions | |||
| how do i convert numbers to words | Excel Worksheet Functions | |||
Linear Mode
