In this article
BAHTTEXT writes a number as Thai text with ‘Baht’. There is no rupee equivalent built in; for Indian amounts in words you need a LAMBDA or VBA (see the LAMBDA Library course).
Advertisement
Syntax
=BAHTTEXT(number)| Argument | What it means |
|---|---|
number |
Amount |
Examples
Example 1
=BAHTTEXT(A2)Result: หนึ่งร้อยบาทถ้วน. See the worked example table below for more cases.
BAHTTEXT in practice
Where you will use it
- Thai invoices and cheques
- Showing how amount-in-words works
- International templates
Worked example
| Amount | Formula | Result |
|---|---|---|
| 100 | =BAHTTEXT(A2) | หนึ่งร้อยบาทถ้วน |
| 1234 | =BAHTTEXT(A3) | หนึ่งพันสองร้อยสามสิบสี่บาทถ้วน |
| 25.5 | =BAHTTEXT(A4) | ยี่สิบห้าบาทห้าสิบสตางค์ |
Results calculated in Excel.
Mistakes people make
| Mistake | What to do instead |
|---|---|
| Expecting English or Hindi | BAHTTEXT only writes Thai |
| Large decimals | Satang (2 decimals) only |
Related functions
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
Advertisement
✨ Ask AI about this article
Stuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong