Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Convert Digits to Words (1000 write One thousand)
I want to get the words for digits...eg. If I enter 4526 in a column , i need
to get "four thousand five hundred twenty six" in another column automatically..... How can I do it? How make a formulae for this. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Convert Digits to Words (1000 write One thousand)
See:
XL2000: How to Convert a Numeric Value into English Words http://support.microsoft.com/default...N-US;Q213360&; and: XL: How to Convert a Numeric Value into English Words http://support.microsoft.com/default...EN-US;q140704& -- Gary''s Student "Excel" wrote: I want to get the words for digits...eg. If I enter 4526 in a column , i need to get "four thousand five hundred twenty six" in another column automatically..... How can I do it? How make a formulae for this. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Convert Digits to Words (1000 write One thousand)
See http://www.xldynamic.com/source/xld.xlFAQ0004.html
-- HTH RP (remove nothere from the email address if mailing direct) "Excel" wrote in message ... I want to get the words for digits...eg. If I enter 4526 in a column , i need to get "four thousand five hundred twenty six" in another column automatically..... How can I do it? How make a formulae for this. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Convert Digits to Words (1000 write One thousand)
The older reference is no longer available. (also applies to Bob's answer)
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert numbers to words (1000 to One Thousand) in Excel | Excel Discussion (Misc queries) | |||
How do you convert a formula cell to a constant cell | Excel Discussion (Misc queries) | |||
Write formula to add "1" to each number in a column | Excel Worksheet Functions | |||
How can I write an if-then formula for 0 or less than 0 in cell t. | Excel Worksheet Functions | |||
how do i convert numbers to words | Excel Worksheet Functions |