ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   BAHTTEXT() Anyother such function return the value in Eglish Txt? (https://www.excelbanter.com/excel-discussion-misc-queries/189558-bahttext-anyother-such-function-return-value-eglish-txt.html)

VJ Sharma

BAHTTEXT() Anyother such function return the value in Eglish Txt?
 
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[_2_]

BAHTTEXT() Anyother such function return the value in Eglish Txt?
 
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?




All times are GMT +1. The time now is 03:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com