The BAHTTEXT function is used to convert a number into Thai text representation, specifically in the baht currency format. This function is particularly useful for financial documents or applications that require amounts to be displayed in Thai Baht words.



number The numerical value that you want to convert into Thai text representation.


When working with financial data in the context of Thailand or using the Thai Baht currency, the BAHTTEXT function comes in handy for representing numerical amounts in the local language format. This function seamlessly transforms numeric figures into their equivalent Thai text representation, making it convenient for producing documents, invoices, or reports in Thai language or currency format. By utilizing BAHTTEXT, you can ensure accurate and culturally appropriate representation of monetary values, contributing to clarity and precision in communicating financial information to Thai-speaking audiences.


If you have the number 123456.78 and you want to display it in Thai Baht text format, you would use the following formula: =BAHTTEXT(123456.78)

Similarly, if you need to represent the number 7890.50 in Thai Baht words, you would use the BAHTTEXT function as follows: =BAHTTEXT(7890.50)


Can the BAHTTEXT function be used for languages other than Thai?

No, the BAHTTEXT function is designed specifically for converting numerical values into Thai text representation, particularly for Thai Baht currency. It is not intended for use with other languages or currency formats.

What range of numbers can the BAHTTEXT function handle?

The BAHTTEXT function can handle a wide range of numerical values, including both whole numbers and decimals, within the precision limits of Excel. It is important to ensure that the input numbers are within the acceptable range for accurate conversion to Thai text representation.

Related functions