The BAHTTEXT function will convert any number into Thai text while applying a "Baht" suffix.
Contents:
Syntax
= BAHTTEXT(number)
number = the number to be converted into Thai text
Explanation
The BAHTTEXT function is part of the "Text" group of functions within Excel.
This function will take any number and convert that number into Thai text while applying the text "Baht" at the end.
The Thai Baht is the official currency of Kingdom of Thailand, the Baht symbol is ฿.
This function will take any number and convert that number into the written out text version in the Thai language.
The Thai numerals are seen here to the left. The function will convert each number into its respective Thai equivalent, and add on "บาทถ้วน" which translates to "Baht".
Here is a an example output for each Arabic numeral and Thai equivalent:
Notes:
- If the input is non-numerical, a #VALUE! error will be returned
- A blank cell will be returned as a zero
Examples
1. How to Convert a Number to Thai Text and Add a "Baht" Suffix
Converting numbers into written Thai text is the primary use of the BAHTTEXT function.
In the below example, we have a table of monthly sales. This formula takes the sales numbers as an input, and converts that number into Thai, and adds the "Baht" suffix.
= BAHTTEXT(C3)