Microsoft Excel – Text Functions – BAHTTEXT, DOLLAR and DBCS formulas

Continuation to our series of Articles of Text Functions; in this Article, we will discuss few more Text Functions from Microsoft Excel.

BAHTTEXT function

This function is used to convert a number to Thai text. This function takes a number or numeric text as an argument and converts it to Thai text. If we pass non-numeric text, this function throws #VALUE! Error.

DOLLAR function

This function is used to convert the number to a text using Currency format. This will use the current local settings of the System. We have the option to pass number of digits required after the decimal.

The Syntax of the function is:

=DOLLAR(number, [digits_after_decimal])

First argument takes number and the optional second argument takes number of digits after the decimal. If you pass non-numeric data through first argument, this function throws #VALUE! Error.

DBCS function (introduced in Office 2013)

We have discussed ASC function in our previous Article; which is used to convert double-byte character string to a single-byte character string. Reverse to this is the DBCS function.

This function is used to convert single-byte character string to double-byte character string.

🙂 Sahida

Microsoft Excel – Text Functions – BAHTTEXT, DOLLAR and DBCS formulas

Leave a Reply

Your email address will not be published.

Scroll to top