The BAHTTEXT function in Excel is used to convert numbers into Thai currency text.
It automatically adds the Thai Baht unit (บาท) and Satang (สตางค์), making it extremely useful in accounting, invoicing,
and legal financial documents in Thailand.
What Is BAHTTEXT?
BAHTTEXT changes a numeric value into written Thai text currency format. For example,
1250.75 becomes “หนึ่งพันสองร้อยห้าสิบบาทเจ็ดสิบห้าสตางค์”.
This function is commonly used for:
- Official receipts
- Invoices
- Contracts
- Thai accounting worksheets
BAHTTEXT Syntax
=BAHTTEXT(number)Arguments
- number – Required. Any number you want to convert to Thai currency words.
Examples of BAHTTEXT
Example 1:
=BAHTTEXT(1250.75)Result:
หนึ่งพันสองร้อยห้าสิบบาทเจ็ดสิบห้าสตางค์
Example 2:
=BAHTTEXT(50)Result:
ห้าสิบบาทถ้วน
Example 3:
=BAHTTEXT(1999)Result:
หนึ่งพันเก้าร้อยเก้าสิบเก้าบาทถ้วน
Download the BAHTTEXT Excel Template
⬇ Download BAHTTEXT_Example.xlsx
This template includes examples of BAHTTEXT applied to multiple numbers so you can practice and understand how the function converts numeric values into Thai Baht text.
Use Cases
- Thai-language receipts
- Invoice systems
- Export documents
- Legal financial contracts
- Bank transaction documents
BAHTTEXT vs Other Excel Text Conversion Functions
While BAHTTEXT is unique to Thai currency, here is how it compares to other Excel text-related functions:
| Function | Description | Currency Text Output | Language Support |
|---|---|---|---|
| BAHTTEXT | Converts a number into Thai Baht text | Yes | Thai only |
| TEXT | Converts numbers to formatted text | No | All languages (format only) |
| DOLLAR | Formats a number as US currency | No (numeric formatting only) | English |
| FIXED | Converts a number to text with fixed decimals | No | All |
Important Notes
- If the number contains no decimal, the output ends with “ถ้วน”.
- Works with both integers and decimals.
- Automatically applies Thai currency grammar rules.
- Only available in Excel—Google Sheets does not support BAHTTEXT.
Final Thoughts
The BAHTTEXT function saves time and reduces errors when creating Thai financial documents. Whether you are preparing invoices or accounting records, this function ensures accurate and formatted Thai currency text output.
Download the free Excel file above and start practicing BAHTTEXT today!
BAHTTEXT Output with Thai to English Translation
Below are some BAHTTEXT outputs translated to English, helpful for readers unfamiliar with Thai currency text.
| Number | BAHTTEXT Output (Thai) | English Translation |
|---|---|---|
| 1250.75 | หนึ่งพันสองร้อยห้าสิบบาทเจ็ดสิบห้าสตางค์ | One thousand two hundred fifty Baht and seventy-five Satang |
| 50 | ห้าสิบบาทถ้วน | Fifty Baht exactly |
| 1999 | หนึ่งพันเก้าร้อยเก้าสิบเก้าบาทถ้วน | One thousand nine hundred ninety-nine Baht exactly |
English to Thai Currency Text Examples
To better understand how BAHTTEXT expresses Thai currency, here are examples showing English amounts and their Thai text equivalents.
| English Amount | Thai Written Form (BAHTTEXT Style) |
|---|---|
| One hundred Baht | หนึ่งร้อยบาทถ้วน |
| Seven hundred fifty Baht and twenty Satang | เจ็ดร้อยห้าสิบบาทยี่สิบสตางค์ |
| Ten thousand Baht | หนึ่งหมื่นบาทถ้วน |
| Twenty-five Baht and fifty Satang | ยี่สิบห้าบาทห้าสิบสตางค์ |