about =bahttext()

[Guest]

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() here:
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.

 

[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.