Skip to main content



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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.