Formats a number into the locale-specific currency format.

Sample Usage




DOLLAR(number, number_of_places)

  • number - The value to be formatted.

  • number_of_places - [ OPTIONAL - 2 by default ] - The number of decimal places to display.


  • The currency format used by DOLLAR is specific to your spreadsheet locale.

  • DOLLAR differs from the related function TO_DOLLARS in that DOLLAR outputs text rather than applying a cell format to a number.

See Also

TO_DOLLARS: Converts a provided number to a dollar value.

In order to use the DOLLAR formula, start with your edited Excellentable:

Then type in the DOLLAR formula in the area you would like to display the outcome:

By adding the values you would like to calculate the DOLLAR formula for, Excellentable will generate the outcome:



User does not have sufficient privileges to access this Content
Learn More