March 21, 2023

How to use the Excel Bahttext function

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:

Excel Bahttext - How to use the Excel Bahttext function

Syntax:  =BAHTTEXT(A16)

Result:

Excel Bahttext function - How to use the Excel Bahttext function

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: หนึ่งร้อยสี่บาทถ้วน

READ:  How to use CHAR Function in Excel?

Leave a Reply

Your email address will not be published. Required fields are marked *