BAHTTEXT() Anyother such function return the value in Eglish Txt?

[VJ Sharma]

I tried to use the function BAHTTEXT() for retuning value in English Text,
but it returns the value in other language not known to me. Kindly suggest me
how should I solve my problem? Is there any function like this or how can I
create this function myself?

 

[Norman Jones]

Hi VJ,

The BAHTTEXT function returns a numeric value in Thai text.

http://office.microsoft.com/en-us/excel/HP100625581033.aspx


To convert a numeric value into English text,
you could download Laurent Longre's
MoreFunc addin which is freely downloadable
at:

http://xcell05.free.fr/

The addin includes the NBTEXT function which
converts a positive number into spelled-out text
(supports 13 languages).

Also see xlDynamic's sugggestions at:

Excel FAQs - Convert Numbers To Text
http://www.xldynamic.com/source/xld.xlFAQ0004.html