|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 18th, 2008, 12:36 PM
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
August 18th, 2008, 12:43 PM
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
August 21st, 2008, 10:56 PM
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"
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
