G Guest Feb 15, 2007 #2 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.
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.
N Niek Otten Feb 15, 2007 #3 http://xldynamic.com/source/xld.xlFAQ0004.html -- Kind regards, Niek Otten Microsoft MVP - Excel | Dear Sir/Madam | | Please give suggestion about mentioned subject
http://xldynamic.com/source/xld.xlFAQ0004.html -- Kind regards, Niek Otten Microsoft MVP - Excel | Dear Sir/Madam | | Please give suggestion about mentioned subject