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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top