PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

EXCEL FUNCTIONS-BAHTTEXT

INTRODUCTION

BAHTTEXT is a function which converts the currency in number to the currency in text.

BAHTTEXT function comes under the TEXT category in Excel.

BAHTTEXT returns the value of the number given into text in Thai language with a suffix of BAHT.

BAHT IS THE CURRENCY OF THAILAND.

BAHTTEXT converts a number to the THAI TEXT suffexed(attached at the end) by BAHT.

i.e.

It’ll convert number of BAHT in number to BAHT in text.

For example if we apply BAHTTEXT FUNCTION to 10 , it’ll return TEN BAHT but in THAI.

THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.

Basic understanding of how to use a formula or function.
Basic understanding of rows and columns in Excel.
Some information about the financial terms is an advantage for the use of such formulas.
Of course, Excel software.

Helpful links for the prerequisites mentioned above

The Syntax for the function is

=BAHTTEXT(NUMBER)

NUMBER is any number.

This function is used to convert THAI CURRENCY IN FIGURE TO THAI CURRENCY TO TEXT.

Let us convert 10 BAHT to ten baht (in THAI).

The data is put in D9 and the function is used in E9
the function used is =BAHTTEXT(D9)
The output has been checked with google translate and it shows TEN BAHT AS EXPECTED.