Wauvel

Excel like a finance pro.

← The library

Text function

BAHTTEXT

Converts a number to Thai text and appends a baht suffix.

Rarely usedDifficulty 1300 · ProficientUsage rank #298 of 520
Practice · 2 questions →

When to use it

Spells out a number in Thai words with the baht currency suffix.

The shape of it

Syntax
=BAHTTEXT(number)

Worked examples

  • Whole baht

    =BAHTTEXT(1234) → หนึ่งพันสองร้อยสามสิบสี่บาทถ้วน

    One thousand two hundred thirty-four baht.

  • Fractional

    =BAHTTEXT(0.5) → ห้าสิบสตางค์

    Fifty satang.

  • Negative

    =BAHTTEXT(-10) → ลบสิบบาทถ้วน

    Negative amounts are prefixed with the word for minus.

Worth knowing

  • There is no English equivalent built in; spelling out dollars needs a custom LAMBDA or VBA.
  • Amounts round to two decimals (satang).
  • The result is text.

Where it goes wrong

  • Only Thai is supported.
  • Fonts without Thai glyphs show boxes.

Related

LEFTRIGHTLENTRIMUPPERLOWER

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.