how i change thai text to english text

M

Mani

BAHTTEXT(number)
Number is a number you want to convert to text, or a reference to a cell
containing a number, or a formula that evaluates to a number

Converts a number to Thai text

In Microsoft Excel for Windows, you can change the Baht format to a
different style by using Regional Settings or Regional Options in Control
Panel.
In Excel for the Macintosh, you can change the Baht number format to a
different style by using Control Panel for Numbers.

I try to change Thai text to English Text however I can’t Change the text

Please assist me on Changing the Test from Thai to English
 
M

macropod

Hello Mani,

In English-language Excel the equivalent function is DOLLAR, another
possibility is FIXED


Syntax

DOLLAR(number,decimals)

Converts a number to text using currency format, with the decimals rounded
to the specified place. The format used is $#,##0.00_);($#,##0.00).

Number is a number, a reference to a cell containing a number, or a
formula that evaluates to a number.

Decimals is the number of digits to the right of the decimal point. If
decimals is negative, number is rounded to the left of the decimal point. If
you omit decimals, it is assumed to be 2.


Syntax

FIXED(number,decimals,no_commas)

Number is the number you want to round and convert to text.

Decimals is the number of digits to the right of the decimal point.

No_commas is a logical value that, if TRUE, prevents FIXED from including
commas in the returned text. If no_commas is FALSE or omitted, then the
returned text includes commas as usual.

.. Numbers in Microsoft Excel can never have more than 15 significant digits,
but decimals can be as large as 127.
.. If decimals is negative, number is rounded to the left of the decimal
point.
.. If you omit decimals, it is assumed to be 2.


Cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top