Quick Navigation

BAHTTEXT Function

Excel 2007+

Summary

The Excel BAHTTEXT function converts numeric values into Thai text representation with a 'Baht' currency suffix, ideal for formal financial documents and receipts in Thailand.

Syntax

BAHTTEXT(number)

Parameters

Parameter	Type	Required	Description
number	`Number`	Yes	The number to convert to Thai currency text (supports decimals for Satang)

Using the BAHTTEXT Function

BAHTTEXT transforms regular numbers into proper Thai Baht currency text format, automatically handling thousands, hundreds, tens, units, and decimal Satang portions with correct Thai numbering conventions and currency suffix.

Common BAHTTEXT Examples

Basic Baht Conversion

=BAHTTEXT(1234)

Converts 1234 to 'หนึ่งพันสองร้อยสามสิบสี่บาทถ้วน' (One thousand two hundred thirty-four Baht even)

Decimal Amount

=BAHTTEXT(1234.5)

Shows 1234 Baht and 50 Satang in proper Thai text format

Cell Reference

=BAHTTEXT(A1)

Converts value in cell A1 to Thai Baht text

Frequently Asked Questions

Decimals represent Satang (1/100 Baht) and appear as 'สตางค์' in the text output

Yes, modify Regional and Language Options in Windows Control Panel for different Baht styles

BAHTTEXT does not support negative numbers properly; results may be unexpected

Common Errors and Solutions

#VALUE! error

Cause: Non-numeric input provided

Solution: Ensure the number argument contains valid numeric data

Incorrect Thai text

Cause: Regional settings mismatch

Solution: Verify Thai language and Baht format in Regional settings

Notes

Outputs Thai Unicode text requiring font support
Perfect for invoices, receipts, contracts in Thailand
'ถ้วน' means 'even' (no Satang)
Available only in Excel 2007 and later versions

Compatibility

Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365

Not available in: Excel 2003, Excel XP, Excel 2000, Excel 97

Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+