Is there a formula to convert numbers to written text in Excel?

[LZC]

I found the =BAHTTEXT() formula to convert to Thai, but can't find anything
to convert in English. For example, I am trying to convert "123" into "one
hundred and twenty three". Can anyone help me?

 

[tjtjjtjt]

There is no built-in way to do this, but you might check this out for
possible solutions:
http://www.excelforum.com/archive/index.php/t-205528.html

tj

 

[Trevor Shuttleworth]

http://support.microsoft.com/default.aspx?scid=kb;en-us;213360

Regards

Trevor

 

[David McRitchie]

There are variations: in the US the word "and" signifies a
decimal point; elsewhere, it may be correct to also place an
"and" somewhere else like in gasping for breath. Perhaps
you don't want to see the words "dollars" or "cents" and/or
perhaps you want the cents spelled out or written as xx/100

Some other webpages to look at in
http://www.mvps.org/dmcritchie/excel/strings.htm#numberstowords
but I wasn't aware of differences in usage of "and" when I wrote
that section and didn't update it when I learned of it.