BAHTTEXT function

The BAHTTEXT function in Excel is used to convert a number into Thai currency text, expressing the number in words, followed by the word “Baht” (the currency of Thailand). It is commonly used in Thailand for converting financial numbers into a readable form in reports or documents.

Syntax

=BAHTTEXT(number)

Parameters

• number (required): The number you want to convert to Thai currency text. This can be a number, a cell reference, or a formula that returns a number.

Key Points

• The function converts a number into Thai currency text, where the number is expressed in words followed by the term “Baht.” If the number is a decimal, it will also convert the fractional part into words, followed by “Satang” (the subunit of the Baht).
• The number is written in Thai script, and the fractional part (if any) is shown in “Satang.”
• The result will always be in Thai, even if your Excel language is set to a different locale.

Example Usage

1. Simple Conversion

If you want to convert the number 1234 to Thai currency text, you can use the following formula:

=BAHTTEXT(1234)

This will return:

หนึ่งพันสองร้อยสามสิบสี่บาท

Which translates to “One thousand two hundred thirty-four Baht.”

2. Handling Decimal Numbers

If you want to convert a decimal number like 1234.56, the BAHTTEXT function will also convert the decimal part into words. The formula would look like this:

=BAHTTEXT(1234.56)

This will return:

หนึ่งพันสองร้อยสามสิบสี่บาทห้าสิบหกสตางค์

Which translates to “One thousand two hundred thirty-four Baht and fifty-six Satang.”

3. Using a Cell Reference

If cell A1 contains the number 2500.75, you can use the following formula to convert it into Thai currency text:

=BAHTTEXT(A1)

This would return:

สองพันห้าร้อยบาทเจ็ดสิบห้าสตางค์

Which translates to “Two thousand five hundred Baht and seventy-five Satang.”

Notes

• Satang: The subunit of the Baht, similar to cents in other currencies, is used when there are decimal values. A Baht is divided into 100 Satang, and the function will convert the decimal portion into words.
• Locale: The function only works with Thai language and is typically used in documents or financial reports in Thailand. If you’re working with different currencies, Excel does not offer a built-in function to convert numbers into words for other currencies directly.
• Negative Numbers: The BAHTTEXT function does not handle negative numbers. If you provide a negative value, it will return an error. You may need to handle this manually if you need to convert negative amounts.

Related Functions

• TEXT: While not specific to currency, the TEXT function can be used to format numbers into different text formats, including custom currency formats (e.g., for USD, EUR, etc.).

  Example:

  =TEXT(1234.56, "[$฿] #,##0.00")
  

• DOLLAR: Converts a number to a text representation of a currency value in a specified format (such as USD or other currencies).

  Example:

  =DOLLAR(1234.56, 2)
  

The BAHTTEXT function is a specialized tool used to convert numbers into their corresponding Thai Baht words, which is especially useful for financial reporting in Thailand. It provides a convenient way to handle currency text in Thai.