Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Spell number
My question is simple. If i type number in Excel, that should spell the
number in another cell. For eg: If i type 252 in one cell, result should be " Two hundred and Fifty two". Please let me know the formula for this. |
#2
|
|||
|
|||
There is a macro for this on the Microsoft website.
OR do a Google Group search for previous answers to this question best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "vishu" wrote in message ... My question is simple. If i type number in Excel, that should spell the number in another cell. For eg: If i type 252 in one cell, result should be " Two hundred and Fifty two". Please let me know the formula for this. |
#3
|
|||
|
|||
Can you please give me macro for this.....please help me...
"vishu" wrote: My question is simple. If i type number in Excel, that should spell the number in another cell. For eg: If i type 252 in one cell, result should be " Two hundred and Fifty two". Please let me know the formula for this. |
#4
|
|||
|
|||
See http://support.microsoft.com/?kbid=213360 "How to convert a numeric
value into English words in Excel". vishu wrote: Can you please give me macro for this.....please help me... "vishu" wrote: My question is simple. If i type number in Excel, that should spell the number in another cell. For eg: If i type 252 in one cell, result should be " Two hundred and Fifty two". Please let me know the formula for this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |