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

CONTENTS

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.

PURPOSE OF BAHTTEXT IN EXCEL

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.

PREREQUISITES TO LEARN BAHTTEXT

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

SYNTAX: BAHTTEXT

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.

EXAMPLE:BAHTTEXT IN EXCEL

DATA SAMPLE

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

EXCEL BAHTTEXT EXAMPLE
EXCEL:BAHTTEXT FUNCTION EXAMPLE

STEPS TO USE BAHTTEXT

  • 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.

OTHER WAYS TO REACH THIS ARTICLE

  • BAHTTEXT FUNCTION USAGE, CONVERT NUMBER TO TEXT CURRENCY

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

gyankosh060309@gmail.com

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: