Practice free

BAHTTEXT function

BAHTTEXT spells a number out in Thai words with the baht currency wording, returned as text. It is niche, used mainly for Thai invoices and cheques.

Example

Read it as a sentence: write the number 1 out as Thai baht text.

Practice this in the app

Syntax

BAHTTEXT(number)

number (required)
The amount to spell out in Thai.

Returns: Thai-language text spelling the amount in baht and satang.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=BAHTTEXT(1234.5) หนึ่งพันสองร้อยสามสิบสี่บาทห้าสิบสตางค์ Number
=BAHTTEXT(0) ศูนย์บาทถ้วน Zero
=BAHTTEXT(-1) ลบหนึ่งบาทถ้วน Negative
=BAHTTEXT("12") สิบสองบาทถ้วน Text number
=BAHTTEXT("a") #VALUE! Bad text

Watch out for

  • Output is Thai script, so the font must support it.
  • Rounds to two decimals (satang).

Where it works

Excel
BAHTTEXT is in every version of Excel from 2007 on.
Google Sheets
No direct equivalent. No equivalent.

Part of Text functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .