Continuation to our series of Articles of Text Functions; in this Article, we will discuss a 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 a number of digits required after the decimal.
The Syntax of the function is:
=DOLLAR(number, [digits_after_decimal])
The first argument takes a number and the optional second argument takes a number of digits after the decimal. If you pass non-numeric data through the 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 a 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 strings to double-byte character strings.
🙂 Sahida