| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
any formula to convert numbers in word form, e.g. "2" as "Two"?
Is there any formula to convert the numerical in word form?
Such as i want to write A B C D E F 1 12 "Twelve" What formula or format should be set in such a case? Please help me. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
any formula to convert numbers in word form, e.g. "2" as "Two"?
Look here for several solutions:
http://xldynamic.com/source/xld.xlFAQ0004.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Neeraj" wrote in message ... | Is there any formula to convert the numerical in word form? | | Such as i want to write | | A B C D E | F | 1 12 "Twelve" | | What formula or format should be set in such a case? | | Please help me. | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation ?:Accepting both Numbers AND specific letters("N","n"," | Excel Discussion (Misc queries) | |||
| How can I convert numbers (ex. "4") to text (ex. "four") | Excel Discussion (Misc queries) | |||
| 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 | |||
Hybrid Mode
