I'm using BAHTTEXT in US English?

[Khalilurrehman Abola]

Dear Sir/Madam

Please give suggestion about mentioned subject

 

[Martin Fishlock]

Hi

Bahttext converts a number to Thai language text and adds a suffix of "Baht"
and/or "satang" the monetary unit used in Thailand."

So
=BAHTTEXT(123.45)
=
หนึ่งร้อยยี่สิบสามบาทสี่สิบห้าสตางค์

using a thai font if your system allows it (try angsana new)

There is no built in english version of this function.

Have a look on Chip's site for code for using English and modify it if your
language requirement is not English.

 

[Niek Otten]

http://xldynamic.com/source/xld.xlFAQ0004.html


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Dear Sir/Madam
|
| Please give suggestion about mentioned subject