Everybody knows that you can do amazing things with Excel, but who would imagine a function like BAHTTEXT? According to Microsoft, this function “Converts a number to Thai text and adds a suffix of Baht.” There are no functions that convert numbers to text in any other language, so why Microsoft chose to develop this function remains a mystery. I’m guessing that one of the developers did it to impress someone who speaks Thai…
Syntax: =BAHTTEXT( number )
The BAHTTEXT function syntax has the following arguments:
- Number (Required) A number you want to convert to text, or a reference to a cell containing a number, or a formula that evaluates to a number.
Example: Let’s look at some Excel BAHTTEXT function examples and explore how to use the BAHTTEXT function as a worksheet function in Microsoft Excel:
Syntax: =BAHTTEXT(A16)
Result:
Based on the Excel spreadsheet above, the following BAHTTEXT examples would return:
Syntax: =BAHTTEXT(A17)
Result: หนึ่งร้อยเอ็ดบาทถ้วน
Syntax: =BAHTTEXT(A18)
Result: หนึ่งร้อยสองบาทถ้วน
Syntax: =BAHTTEXT(A19)
Result: หนึ่งร้อยสามบาทถ้วน
Syntax: =BAHTTEXT(A20)
Result: หนึ่งร้อยสี่บาทถ้วน