Text

BAHTTEXT Function in Excel

Converts a number to Thai text and adds the suffix Baht.

Syntax

  • =BAHTTEXT(number)

Arguments

  • number (required): Number to convert

Examples

  • =BAHTTEXT(1234.5) - Convert to Thai Baht text - Result: Thai text

Excel BAHTTEXT function documentation

  • BAHTTEXT converts a number to Thai text with baht currency wording.
  • Syntax: =BAHTTEXT(number). It is mostly used in Thai-language invoice and check outputs.
  • Use BAHTTEXT when legal or accounting processes require amount-in-words formatting.
  • Text function category: [/categories/text/](/categories/text/).

BAHTTEXT syntax and formatting notes

  • number is required and can reference a numeric cell or formula result.
  • The output is localized Thai text and not intended for arithmetic operations.
  • Use ROUND before BAHTTEXT when you need strict decimal precision control.
  • For multilingual documents, keep numeric and words fields side by side.

Step-by-step: generate amount in words for invoices

  • Step 1 - Store invoice total in B2 as a numeric currency value.
  • Step 2 - In C2 use =BAHTTEXT(B2).
  • Step 3 - Keep B2 for calculations and C2 for print-friendly wording.
  • Step 4 - Use [TEXT](/functions/text/) in another column for formatted numeric display.

BAHTTEXT vs TEXT vs custom wording

  • BAHTTEXT creates Thai currency words for official-style documents.
  • TEXT formats numbers visually but does not convert numbers to words.
  • Custom LAMBDA solutions may support other languages but require maintenance.
  • Include the numeric source value to avoid reconciliation issues.

Worked examples to copy

  • Basic conversion: =BAHTTEXT(1250.5).
  • Cell reference: =BAHTTEXT(A2).
  • Rounded first: =BAHTTEXT(ROUND(A2,2)).
  • Invoice output pair: =TEXT(A2,"#,##0.00") and =BAHTTEXT(A2).

People also ask

  • Is BAHTTEXT available in all Excel versions? - Availability depends on Excel build and locale support.
  • Can BAHTTEXT output English words? - No, it is designed for Thai baht wording.
  • Does BAHTTEXT return text? - Yes, always text, not a numeric value.
  • Can I use BAHTTEXT in totals? - No, keep numeric values for calculations.

Common errors

  • Specific to Thai currency

Use cases

  • Thai currency
  • Check writing
  • Localization

Frequently asked questions

  • What is BAHTTEXT used for? BAHTTEXT converts a number to Thai text with the Baht currency suffix. It's used in Thailand for writing amounts in words on checks and official documents, similar to how English speakers write 'One Hundred Dollars'.
  • Is BAHTTEXT available in all Excel versions? BAHTTEXT is available in all Excel versions but is primarily useful for Thai language users. It converts numbers to Thai script, so the output will appear as Thai characters. Non-Thai users rarely need this function.
  • How do I convert numbers to words in English? Excel doesn't have a built-in function for English number-to-words. You'd need VBA or a custom function. BAHTTEXT only works for Thai. For other languages, consider third-party add-ins or custom solutions.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.

When to use BAHTTEXT

  • Thai currency — common Text scenario for BAHTTEXT.
  • Check writing — common Text scenario for BAHTTEXT.
  • Localization — common Text scenario for BAHTTEXT.

BAHTTEXT in the Text category

  • Browse all Text functions at /categories/text/ for related formulas.
  • BAHTTEXT syntax: =BAHTTEXT(number)
  • number (required): Number to convert
  • Confirm BAHTTEXT arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.

Formula checklist before you copy down

  • Confirm BAHTTEXT arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.
  • If results look wrong, check for text stored as numbers and invisible spaces with TRIM.
  • Spot-check three known input rows manually against expected output.

Related Excel functions

  • TEXT (/functions/text-function/): Converts a value to text in a specified number format.
  • DOLLAR (/functions/dollar/): Converts a number to text in currency format.
  • FIXED (/functions/fixed/): Formats a number as text with a fixed number of decimals.

Errors to watch for

  • Specific to Thai currency — review causes on linked error pages in the directory.

Copy-paste audit workflow

  • Enter BAHTTEXT on three test rows with known expected output documented on a QA tab.
  • Fill down only after absolute references are locked on lookup tables and rate tables.
  • Compare against manual calculation or a calculator for financial and statistical functions.
  • Search this directory for comparison guides when choosing between similar functions in the same category.

BAHTTEXT worked examples to copy

  • =BAHTTEXT(1234.5) — Convert to Thai Baht text. Expected result: Thai text.

BAHTTEXT reference summary for crawlers and offline review

  • BAHTTEXT belongs to the Text category in Excel. Converts a number to Thai text and adds the suffix Baht.
  • Full syntax: =BAHTTEXT(number). Open /functions/bahttext/ for parameters, FAQs, and related pages.
  • Common mistakes: Specific to Thai currency
  • Pair this function with comparison guides when another Excel formula might fit the same task better.
  • Review fix-excel-formula-errors when unexpected errors appear after upgrading Excel or sharing across locales.