Skip to content
TechSolve

Baht Text Converter

Convert numbers to Thai baht text like Excel's BAHTTEXT: 1,250.50 → หนึ่งพันสองร้อยห้าสิบบาทห้าสิบสตางค์, 21 → ยี่สิบเอ็ดบาทถ้วน. English amount in words too, plus a list mode for whole columns.

Baht Text Converter

How to use Baht Text Converter

  1. 1Type or paste an amount, e.g. 1,250.50.
  2. 2Read the Thai and English text as you type.
  3. 3Copy the text, or switch to List to convert many amounts at once.

What it does

  • Same output as Excel's BAHTTEXT
  • Correct เอ็ด, ยี่สิบ and repeating ล้าน
  • Satang rounded to 2 decimals
  • English words: “… baht and … satang”
  • List mode: paste a column, copy all results

FAQ

When is the number 1 read as เอ็ด?
When 1 is in the units place and there are other digits before it: 11 is สิบเอ็ด, 101 is หนึ่งร้อยเอ็ด, 1,000,001 is หนึ่งล้านเอ็ด. On its own, 1 is หนึ่ง, and 10 is just สิบ.
When does it end with ถ้วน?
ถ้วน means “exactly”: it's added when there are no satang, so 500 is ห้าร้อยบาทถ้วน. With satang the text ends in สตางค์ instead, e.g. 500.25 is ห้าร้อยบาทยี่สิบห้าสตางค์.
How are amounts over a million written?
Thai counts in groups of six digits, so ล้าน repeats: 21,000,000 is ยี่สิบเอ็ดล้าน, and 1,000,000,000,000 is หนึ่งล้านล้าน.
How do I do this in Excel or Google Sheets?
Excel has =BAHTTEXT(A1). Google Sheets has no built-in BAHTTEXT, so you can paste a column into List mode here and copy the results back as a table.
What happens to more than 2 decimal places?
Amounts are rounded to the nearest satang first, half up: 10.005 becomes สิบบาทหนึ่งสตางค์.

You might also like