How do I get Arabic numbers converted to English text format?

K

Kantoo

I am using Office 2003. I use Excel very frequently for my office solutions.
There is a function viz 'BahtText' that converts Arabic number values to
Thai Text format.
Is there any similar function to convert the number values to English Text
format?

For eg. $ 500 shall be converted as "Dollars Five hundred".
 
R

Ron Rosenfeld

I am using Office 2003. I use Excel very frequently for my office solutions.
There is a function viz 'BahtText' that converts Arabic number values to
Thai Text format.
Is there any similar function to convert the number values to English Text
format?

For eg. $ 500 shall be converted as "Dollars Five hundred".

You could use the NBTEXT function in the free morefunc.xll add-in written by
Laurent Longre and available at http://xcell05.free.fr

However, the common usage would be to convert $500 to Five Hundred Dollars, so
if you must have the Dollars first, you may have to add some text.

For example, with 500 in A1:

=NBTEXT(A1,2,2,"dollar!","dollars") -->Five hundred dollars


To display the "Dollars" first, you'd need something like:

=IF(INT(A1)=1,"Dollar ","Dollars ")&NBTEXT(A1,2,2)

Note that neither of the above displays "cents" as you did not specify how you
want them displayed.






--ron
 

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