Formula Convert Digits to Words (1000 write One thousand)

[Guest]

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.

 

[Guest]

See:

XL2000: How to Convert a Numeric Value into English Words
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213360&;

and:

XL: How to Convert a Numeric Value into English Words
http://support.microsoft.com/default.aspx?scid=KB;EN-US;q140704&

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.xlFAQ0004.html

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[David McRitchie]

The older reference is no longer available. (also applies to Bob's answer)