software

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 quot;Dollars Five hundredquot;.

On Sun, 5 Mar 2006 19:26:28 -0800, Kantoo gt;
wrote:

gt;I am using Office 2003. I use Excel very frequently for my office solutions.
gt;There is a function viz 'BahtText' that converts Arabic number values to
gt;Thai Text format.
gt;Is there any similar function to convert the number values to English Text
gt;format?
gt;
gt;For eg. $ 500 shall be converted as quot;Dollars Five hundredquot;.

You could use the NBTEXT function in the free morefunc.xll add-in written by
Laurent Longre and available at 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,quot;dollar!quot;,quot;dollarsquot;) --gt;Five hundred dollarsTo display the quot;Dollarsquot; first, you'd need something like:

=IF(INT(A1)=1,quot;Dollar quot;,quot;Dollars quot;)amp;NBTEXT(A1,2,2)

Note that neither of the above displays quot;centsquot; as you did not specify how you
want them displayed.
--ron