English Words (Invoices & Cheques)
Thai Script (BAHTTEXT)
Excel Formula Equivalent
=BAHTTEXT(D15))Complete Guide: Converting Thai Baht (BAHTTEXT) & Numbers into English Words for Invoices & Cheques
Spelling out numeric values into formal English words is a mandatory accounting standard worldwide and an essential compliance practice in Thailand. Under Thai Revenue Department regulations and commercial banking laws, official financial instruments—including Tax Invoices (ใบกำกับภาษี), Official Receipts (ใบเสร็จรับเงิน), Withholding Tax Certificates (50 ทวิ), Bank Cheques, and Legal Commercial Contracts—must present the grand total amount in both numeric digits and written words. In the event of any discrepancy between the numbers and the words, the amount written in words legally supersedes the numeric figures.
📋 1. The Excel =BAHTTEXT() Limitation
- Native Thai Formula: Microsoft Excel includes a built-in formula
=BAHTTEXT(number), which automatically converts numbers into Thai script (e.g., หนึ่งพันบาทถ้วน). - No Native English Formula: Excel provides no native function (such as =SPELLNUMBER or =NUMBERTOWORDS) to spell amounts in English words.
- The ITKB Advantage: Instantly generates both the formal English words and the corresponding Thai BAHTTEXT script side-by-side with zero macro setup.
🖋️ 2. Official English Standards for Thai Baht
- Formal Cheque Format: Standard corporate cheques require Title Case capitalization, explicit declaration of subunits (Satang), and the concluding keyword "Only".
- Example with Satang:
THB 1,250.50must be spelled as:
"One Thousand Two Hundred Fifty Baht and Fifty Satang Only". - Example without Satang:
THB 5,000.00must be spelled as:
"Five Thousand Baht Only".
🟢 3. Solutions for Google Sheets Users
- No BAHTTEXT Support: Google Sheets does not support
=BAHTTEXT()natively, returning a#NAME?error when entered. - Complex Workarounds: Users typically have to write custom Google Apps Scripts (GAS) or install unverified third-party marketplace add-ons.
- Lightweight Solution: Calculate your sums in Google Sheets, paste the total into ITKB, and copy the legally compliant text directly into your spreadsheet.
🌍 4. Multi-Currency Accounting Formats
- US Dollar (USD): Spelled as
... US Dollars and ... Cents Only(or single US Dollar / Cent). - Euro (EUR): Spelled as
... Euros and ... Cents Only. - British Pound (GBP): Spelled as
... Pounds and ... Pence Only(or single Penny). - Plain Numbers: Spells integers and decimals without currency suffixes (e.g., "Point Five Zero") for commercial lease agreements and asset counts.
Standard Grammar Rules for Writing Numbers in Financial Documents
When drafting export invoices, foreign exchange contracts, or cross-border payment orders, following precise English grammatical standards prevents audit rejection:
Hyphenation of Compound Numbers
Always hyphenate compound numbers between 21 and 99 in formal text.
e.g. Twenty-One, Thirty-Five, Ninety-NineScale Separation (Singular Form)
Higher scales remain singular when denoting an exact count.
e.g. "Five Thousand" (never "Five Thousands")Fractional Subunits
Fractional currency must explicitly specify subunit names rather than raw digits.
e.g. Fifty Cents or Twenty-Five SatangThe "Only" Security Anchor
Always terminate the spelled-out amount with "Only" to prevent fraudulent additions.
e.g. "... Baht and Fifty Satang Only"Frequently Asked Questions (FAQ)
How do you convert Thai Baht numbers into English words in Microsoft Excel?
Microsoft Excel does not possess a built-in formula to convert Thai Baht (or any number) into English words; its native =BAHTTEXT() function only translates numbers into Thai script. To obtain English currency words without writing custom VBA Macro scripts, enter your amount on itkb.app to generate formal Title Case English words alongside native Thai script instantly.
What is the difference between =BAHTTEXT() and =SPELLNUMBER()?
=BAHTTEXT() is an official built-in Microsoft Excel formula designed specifically for the Thai language and currency. In contrast, =SPELLNUMBER() is not a standard built-in formula—it is a custom User Defined Function (UDF) that users must manually code in VBA Macro. Many corporate IT environments disable macros due to cybersecurity policies, making browser-based conversion via ITKB a safer, zero-install alternative.
How should Thai Baht be written on an international commercial invoice?
On international invoices issued in Thailand, write the currency code (THB), the numeric total, and the full English verbal string in Title Case. For example: "THB 105,400.00 (Say: Thai Baht One Hundred Five Thousand Four Hundred Only)". If the invoice is submitted to the Thai Revenue Department, including the Thai BAHTTEXT script is also highly recommended.
Does Google Sheets have a built-in BAHTTEXT formula?
No. Google Sheets does not support the =BAHTTEXT() formula out of the box. Users must write a custom script using Google Apps Script (under Extensions > Apps Script) or use an online browser-based tool like ITKB to convert the numbers and copy the resulting text into their sheet.
Is my financial and payroll data kept private when using this converter?
Yes, 100%. Under ITKB's Decade-Proof & Privacy-First engineering mandate, all number parsing and string conversions execute strictly within your local browser's JavaScript sandbox. No financial data, transaction numbers, or metadata are ever transmitted to or stored on external web servers. The tool remains fully operational even when disconnected from the internet.