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

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

Similar Threads

How can we convert number in to english text? 2
How do I get Arabic numbers converted to English text format? 1
how i change thai text to english text 1
Conversion of a Number into English Text 1
what formula converting number to text in english or hindi in exl 1
Convert Numbers to Text 2
How to convert number into word in excel i.e. 100 to one hundred 1
convert number to english text. example: 2=two, 100=hundred 2

Top