DOLLAR function
DOLLAR converts a number to an amount in the currency format, rounded to a specified decimal place. You set the currency format in your system settings.
Syntax
DOLLAR (value, decimals)
- value is a number, a reference to a cell containing a number, or a formula which returns a number.
- decimals is the number of decimal places.
Note: If no value is specified, all numbers
in currency format will be displayed with two decimal places.
Example
=DOLLAR(255) returns $255.00.
=DOLLAR(367.456,2) returns $367.46. Use the decimal separator that corresponds to the current locale setting.