Here, we will learn how to use the Excel text functions: TEXT, DOLLAR and FIXED.
TEXT function
The Excel TEXT function returns the given number in the given numeric format in the text format. For example, =TEXT(4,"#/#") returns 4/1. TEXT takes the arguments like this: value, format_text, all of which are required. Value accepts the numeric value that needs to be formatted as text. It can be a cell reference or added directly in the formula. Format_text accepts the number formatting code (enclosed in the double-quotes) to apply to the given value. It is usually added directly in the formula.
DOLLAR function
The Excel DOLLAR function converts the given number to the text format using currency format, with the decimals rounded to the specified place. For example, =DOLLAR(1234.567,2) returns ₹ 1,234.57. It displays the number in the currency format and 2 digits to the right of the decimal point. The currency symbol used is based on the language settings of the computer. DOLLAR takes the arguments like this: number, [decimals], out of which number is required. Number accepts the numeric value that needs to be formatted using the currency. It can be a cell reference or added directly in the formula. Decimals specifies the number of digits to show to the right of the decimal point, and rounds the number accordingly. It is usually added directly in the formula. Omitting the argument will force the function to take the default value of 2. The formula in G4, copied down, is:
=DOLLAR(E4,F4)
FIXED function
The Excel FIXED function converts the given number to the text format, with the decimals rounded to the specified place. For example, =FIXED(1234.567,2) returns 1,234.57. FIXED takes the arguments like this: number, [decimals], [no_commas], out of which number is required. Number accepts the numeric value that needs to be converted to the text format. It can be a cell reference or added directly in the formula. Decimals specifies the number of digits to show to the right of the decimal point, and rounds the number accordingly. It is usually added directly in the formula. Omitting the argument will force the function to take the default value of 2. No_commas is Boolean (TRUE/FALSE) that controls whether commas will be added or not. Supplying TRUE will not add commas. Omitting the argument will force the function to take the default value of FALSE, that will add commas. The formula in L4, copied down, is:
=FIXED(I4,J4,K4)
You have successfully learnt how to use the Excel text functions: TEXT, DOLLAR and FIXED.
