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.
A
B
C
D
1
หนึ่งบาทถ้วน
2
3
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.
| Formula | Excel shows | Case |
|---|---|---|
=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 .