Formulas > =BAHTTEXT()
BAHTTEXT Google Sheets Formula
Description
How To Actually Use BAHTTEXT() in Sheets
BAHTTEXT(number)
When to use BAHTTEXT
BAHTTEXT is built for Thai invoices, receipts, and checks where the amount must appear as words, not digits. Whole numbers get the บาท (Baht) suffix. Decimal values use สตางค์ (Satang).
For locale currency formatting in other regions, see DOLLAR or TEXT.
Examples
=BAHTTEXT(120)หนึ่งร้อยยี่สิบบาทถ้วน
0.75=BAHTTEXT(0.75)เจ็ดสิบห้าสตางค์
120.75=BAHTTEXT(120.75)หนึ่งร้อยยี่สิบบาทเจ็ดสิบห้าสตางค์
0=BAHTTEXT(0)ศูนย์บาทถ้วน
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
More related tutorials
Transcript-matched member videos for BAHTTEXT(). Click through to watch.
Google Sheet Basics - The Absolute Basics
Learn more about the BAHTTEXT() formula:
Generate a BAHTTEXT() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses BAHTTEXT(). 2 free AI generations, no signup. Members get unlimited use.
Generate a BAHTTEXT() formula