Contact
12 programs
Explore the site

BAHTTEXT in Excel: Thai Baht Amounts Written as Words

Text Intermediate Microsoft Excel

Convert numeric baht amounts into Thai words with BAHTTEXT, retain a numeric total for calculations and understand the limits of documented rounding and locale behavior.

Verification status: See the evidence and test scope described in this guide. How formula examples are checked

BAHTTEXT converts a numeric amount into Thai currency words. It is useful for a written-amount line beside a numeric baht total. The result is text: it does not convert foreign currencies, obtain an exchange rate, or change the underlying numeric amount into another currency.

For example, the whole-baht amount 25 has the independently reviewed Thai wording ยี่สิบห้าบาทถ้วน, meaning twenty-five baht exactly. Keep the original 25 in a numeric cell for arithmetic, and put the words in a separate presentation cell.

Syntax and input

=BAHTTEXT(number)

There is one required argument. Microsoft documents a number, a reference to a numeric cell, or an expression that evaluates to a number. Its published example demonstrates whole-baht Thai text ending in บาทถ้วน. Microsoft BAHTTEXT reference

The reference does not supply a full decimal-rounding, negative-amount, large-number or invalid-input error specification. The original examples here therefore use modest positive whole-baht amounts. Specific error tokens, satang tie-rounding and exact strings for arbitrary decimal values are not inferred from the function name.

A simple worksheet layout

Enter the following fictional amounts as numbers, without embedding a currency label in the input:

Cell Numeric amount
A2 25
A3 100
A4 35
  1. Put =BAHTTEXT(A2) in B2. The independent linguistic expectation is ยี่สิบห้าบาทถ้วน.
  2. Put =BAHTTEXT(A3) in B3. The expectation is หนึ่งร้อยบาทถ้วน.
  3. Put =BAHTTEXT(A4) in B4. The expectation is สามสิบห้าบาทถ้วน.
  4. Keep column A for numeric calculations. Column B is the written-amount presentation.

The word components help make the examples inspectable: ยี่สิบ means twenty, ห้า means five, หนึ่งร้อย means one hundred, and สามสิบ means thirty. บาท names the baht unit; ถ้วน marks an exact whole-baht amount. These explanations support the chosen text expectations, rather than certifying an application’s font, line wrapping or every Thai number-spelling boundary.

Original whole-baht controls

Formula Independent text expectation English meaning
=BAHTTEXT(25) ยี่สิบห้าบาทถ้วน Twenty-five baht exactly
=BAHTTEXT(100) หนึ่งร้อยบาทถ้วน One hundred baht exactly
=BAHTTEXT(35) สามสิบห้าบาทถ้วน Thirty-five baht exactly
=BAHTTEXT(200) สองร้อยบาทถ้วน Two hundred baht exactly
=BAHTTEXT(125) หนึ่งร้อยยี่สิบห้าบาทถ้วน One hundred twenty-five baht exactly

These are small, explicitly chosen linguistic controls. They are not native execution captures or a comprehensive Thai numeral-generation algorithm. Use competent language review for documents where an incorrect written amount could have consequences.

Practical case: one numeric total, one written total

Suppose two fictional line amounts are 25 and 100 baht in A2:A3. Calculate their total in A5:

=A2+A3

A5 is numerically 125. Then enter =BAHTTEXT(A5) in B5. The independent wording expectation is หนึ่งร้อยยี่สิบห้าบาทถ้วน.

This keeps the written amount connected to the same total used elsewhere in the sheet. It also makes checking straightforward: 25 + 100 = 125, with one hundred plus twenty-five represented in the Thai words. Avoid adding written strings together or retyping the total into a separate formula; those approaches can let the numeric and written amounts drift apart.

A currency number format changes how a numeric cell is displayed. BAHTTEXT instead produces words. Neither operation supplies exchange-rate conversion. If the source amount is in another currency, establish the conversion and its date separately before passing a baht-denominated number to this function.

Decimal amounts, locale and troubleshooting

Whole-baht examples avoid the unresolved rounding boundaries in the reviewed page. If a document contains fractions of a baht, decide and validate the numeric rounding rule before creating its written amount. Merely showing two decimal places does not necessarily change the stored number. This guide does not promise which satang wording or midpoint rounding a particular build produces.

Microsoft mentions desktop regional settings in its description, but the page does not establish exhaustive platform-specific behavior or turn BAHTTEXT into a general multilingual currency-word converter. Do not change machine settings simply to assume a formula contract has changed. Preserve numeric inputs and check the displayed words in the intended recipient’s workflow.

The reviewed reference supplies no comprehensive invalid-input error table. Use a numeric cell rather than relying on locale-sensitive parsing of text such as an amount with separators or a currency label. Negative amounts, zero, very large values and special Thai spelling cases outside the table require their own verification.

Related: SUM can build the numeric total; ROUND applies an explicit numeric precision rule; TEXT concerns formatted text rather than Thai amount words.

Availability and evidence

Microsoft’s dedicated reference, checked October 18, 2026, lists Excel for Microsoft 365 on Windows and Mac, Excel 2024 on Windows and Mac, Excel 2021 on Windows and Mac, Excel 2019 and Excel 2016. This is the documented product scope, not a record of execution on those releases. First introduction and last functioning build are unknown; the product list does not establish either. The reference continues to document this function; it does not establish a retirement date.

The examples here are independently calculated or explicitly identified as documented expectations. No Excel application or other spreadsheet engine was run, and no native screenshots are supplied. Very large amounts and locale-sensitive inputs require separate validation.

Official BAHTTEXT reference.