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

L

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?
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top