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?

Hi VJ,

The BAHTTEXT function returns a numeric value in Thai text.

http://office.microsoft.com/en-us/ex...625581033.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




---
Regards.
Norman


"VJ Sharma" <VJ wrote in message
...
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?