![]() |
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? |
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