BAHTTEXT

Convert a number to Thai text in the Thai Baht currency format with BAHTTEXT.

Text
|
Excel All versions
|
Google Sheets Not supported

Spreadsheet editor

Syntax

=BAHTTEXT(number) Returns: Text

Arguments

Argument Required Description
number Yes The number you want to convert to Thai Baht text. Can be a value, a cell reference, or a formula that returns a number.

About

BAHTTEXT takes a number and converts it into Thai words that spell out the amount in Baht and Satang (the subunit of Thai Baht). The result is a text string written entirely in Thai characters. This is the only built-in Excel function that converts numbers to a specific language's currency text.

Use BAHTTEXT when you need to print Thai Baht amounts in words on invoices, checks, or official financial documents. Thai business and legal documents often require monetary values to be written out in full, and BAHTTEXT handles this automatically. The function works with both whole numbers and decimals, where the integer part represents Baht and up to two decimal places represent Satang.

For general number-to-text formatting in other currencies or languages, try TEXT with a custom format code. If you need to convert text back to a number, see VALUE. To join the BAHTTEXT result with other text, use CONCAT or TEXTJOIN.

Examples

Negative numbers and zero balance

See how BAHTTEXT handles negative amounts and zero. Negative values get a Thai 'minus' prefix, while zero produces its own distinct text. Try changing the amounts to see how refunds and credits look in words.

Spreadsheet editor

Decimal precision beyond two places

Watch what happens when your number has more than two decimal places. BAHTTEXT silently drops extra decimals, which can cause mismatches. Wrap it in ROUND to control rounding before conversion.

Spreadsheet editor

Building pay slip text with CONCAT

Use CONCAT to combine an employee name with BAHTTEXT output for pay slip lines. Edit the salaries and see the Thai text update instantly alongside each name.

Spreadsheet editor

Watch out for

⚠

Expecting output in English or another language

BAHTTEXT always returns Thai characters. There is no option to get English or any other language output from this function.

→ For English currency words, you would need a custom VBA function or a helper formula. BAHTTEXT is designed only for Thai Baht text.

⚠

Passing text instead of a number

If the argument is a text string that cannot be read as a number, BAHTTEXT returns a #VALUE! error.

→ Make sure the input is a number or a cell containing a numeric value. Use VALUE to convert text that looks like a number before passing it to BAHTTEXT.

⚠

Decimal precision beyond two places

BAHTTEXT only considers up to two decimal places (Satang). Extra decimal digits are ignored, which can lead to unexpected rounding.

→ Round your value to two decimal places first with ROUND if precision matters: =BAHTTEXT(ROUND(A1,2)).

Tips & notes

BAHTTEXT is specific to Thai Baht. Excel does not offer similar built-in functions for other currencies. The function is available in all Excel versions, but it is not supported in Google Sheets.

Common questions

Can BAHTTEXT convert amounts in other currencies?

No. BAHTTEXT only works with Thai Baht. It always outputs Thai characters representing Baht and Satang. For other currencies, you would need a custom solution.

Does BAHTTEXT work in Google Sheets?

No. BAHTTEXT is an Excel-only function and is not available in Google Sheets.

What happens if I pass a negative number to BAHTTEXT?

BAHTTEXT converts negative numbers the same way as positive ones, but adds the Thai word for 'minus' at the beginning of the result string.