ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   about =bahttext() (https://www.excelbanter.com/excel-worksheet-functions/7008-about-%3Dbahttext.html)

Rao Ratan Singh

about =bahttext()
 
Dear any sir or mam
Yu all know tha this =bahtext() works to displya numeric value into text in
thai language but how it can be possible so that it can displya numeric value
into englisht text value like =bahttext(100) Hundred.

I will be very grateful if u can solve my proble.


Arvi Laanemets

Hi

Read about BAHTTEXT() he
http://www.j-walk.com/ss/excel/odd/odd20.htm

To be short, for all other languages, you have to write an UDF to achieve
same functionality. For english one I advice to search MS Knowledge Base.


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)



"Rao Ratan Singh" wrote in message
...
Dear any sir or mam
Yu all know tha this =bahtext() works to displya numeric value into text

in
thai language but how it can be possible so that it can displya numeric

value
into englisht text value like =bahttext(100) Hundred.

I will be very grateful if u can solve my proble.




JE McGimpsey

You've been given an answer at least 5 times in the last week, and
you'll get the same answer no matter how many times you continue to
post. Bahtext() does not have an equivalent in English. You'll need to
use a macro.

In article ,
Rao Ratan Singh wrote:

Dear any sir or mam
Yu all know tha this =bahtext() works to displya numeric value into text in
thai language but how it can be possible so that it can displya numeric value
into englisht text value like =bahttext(100) Hundred.

I will be very grateful if u can solve my proble.



All times are GMT +1. The time now is 10:13 AM.

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