DOLLAR Function Explained
The DOLLAR function in Microsoft Excel is used to convert a number to text, using a currency format. It takes two arguments: the number to be converted, and the number of decimal places to display. The function returns a text string, with the currency symbol and the specified number of decimal places.
DOLLAR Function Syntax
DOLLAR(number, [decimals])
- number: The number that you want to convert to text using currency format.
- decimals: (optional) The number of digits to the right of the decimal point. If omitted, it is assumed to be 2.