How to use the DOLLAR function to convert number to currency
In Excel, the DOLLAR function is used to convert a number to text format as well as add a currency symbol. The DOLLAR Function’s syntax also allows us to set how many decimal places to round the currency. Here is the syntax that is used for the DOLLAR Function.
DOLLAR(number, decimals)
number: This refers to a number, reference to a cell that contains a number or a formula that calculates a value.
decimals: The number of digits to the right of the decimal point. If negative, number is rounded to the left of the decimal point. If omitted, Excels default value is 2.
How to use the DOLLAR Function in Excel
- Enter your numeric values in cells A1:A10
- Select cells B1:B10 and ENTER the following formula: =DOLLAR(A1,2).
- Press CTRL+Enter.
What will is happen is your numercic values will be converted to text and rounded to 2 decimal places and a currency symbol would also be added. This tip should work in Excel 97, 2000, 2003 and 2007.
