| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to express number "9" to "Nine"
I want to express a number in to text format
2235 to "Two thousand two hundred thirtyfive" |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to express number "9" to "Nine"
Hi,
There are lots of exaples of code to do this on the net which you could Google. This is as good as any http://www.ozgrid.com/VBA/ValueToWords.htm Mike "Zahir Alam" wrote: I want to express a number in to text format 2235 to "Two thousand two hundred thirtyfive" |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to express number "9" to "Nine"
There are several ways to do it. This is my favorite:
http://www.xldynamic.com/source/xld.xlFAQ0004.html Regards, Ryan--- -- RyGuy "Mike H" wrote: Hi, There are lots of exaples of code to do this on the net which you could Google. This is as good as any http://www.ozgrid.com/VBA/ValueToWords.htm Mike "Zahir Alam" wrote: I want to express a number in to text format 2235 to "Two thousand two hundred thirtyfive" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| how i convert "100" to "hundred"( number to text) in excel-2007 | Excel Worksheet Functions | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Linear Mode
