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.


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.


=DOLLAR(255) returns $255.00.

=DOLLAR(367.456,2) returns $367.46. Use the decimal separator that corresponds to the current locale setting.