Excel - BAHTTEXT Function
BAHTTEXT Function
The BAHTTEXT function transforms a numeric value into Thai text, and the "Baht" suffix is to be embedded. This function benefits Thai natives who want to monitor the monthly financial dataset in the THAI currency. It is helpful to verify the Thai customer's monetary invoices, save experts precious time, provide training to teach the learners about the THAI currency in words, etc.
Compatibility
This advanced Excel function is compatible with the following versions of MS Excel −
- Excel for Microsoft 365
- Excel for Microsoft 365 for Mac
- Excel for the web
- Excel 2024
- Excel 2024 for Mac
- Excel 2021
- Excel 2021 for Mac
- Excel 2019
- Excel 2016
- Excel 2013
- Excel 2010
- Excel 2007
Syntax
The syntax of BAHTTEXT function is as follows −
BAHTTEXT (number)
Arguments
You can use the following arguments with the BAHTTEXT function −
| Argument | Description | Required / Optional |
|---|---|---|
| Number | It specifies a numeric value, cell reference/formula whose result after computation is also number. | Required |
Points to Remember
- The Excel desktop application's Baht formatting can be changed to a variety of styles by selecting the Regional and Language Options in the Control panel of the system.
- If you specify the non-numeric value, then the BAHTTEXT function will retrieve the #VALUE! Error.
- If the argument points to an error, then the BAHTTEXT function will return the same error value.
Use of BAHTTEXT Function
The step-by-step instructions are given below −
- Expedite an Excel worksheet.
- Double-click on the targeted cell, write the = sign, and then BAHTTEXT(a numeric value or cell reference that points to an integer).
- Hit the Enter tab to evaluate the BAHTTEXT function, where you will get the resulting value in Thai text.
Examples of BAHTTEXT Function
Practice the following examples to learn the use of the BAHTTEXT function in Excel.
Example 1: How to Display Thai Text in Excel?
Step 1 − First, consider the sample dataset, which consists of two columns named Number and Result.
Step 2 − After that, select the C3 cell and write the formula =BAHTTEXT(B3).
Step 3 − Afterward, hit the Enter tab.
Therefore, the seven hundred fifty-five baht is written in Thai text.
Step 4 − You can directly specify the numeric value in the BAHTTEXT function. Write the formula =BAHTTEXT(3213) in the C4 cell and press Enter.
Therefore, the BAHTTEXT function retrieves the text in Thai language.
Step 5 − Suppose a cell reference contains a formula, and then you can utilize the BAHTTEXT function enclosed around that formula. For instance: Write the formula =BAHTTEXT(SUM(12,30)) in the C6 cell.
And then, press the Enter tab.
Example 2
If you specify the non-numeric value, then the BAHTTEXT function will retrieve the #VALUE! Error.
Solution
Move to example 2 worksheet and enter the formula =BAHTTEXT("accessibility") in the B2 cell.
When you press the Enter tab, the BAHTTEXT will retrieve the #VALUE! error.
Download Practice Sheet
You can download and use the sample data sheet to practice the BAHTTEXT function.