Formats a number into the locale-specific currency format.
number- The value to be formatted.
number_of_places- [ OPTIONAL -
2by default ] - The number of decimal places to display.
The currency format used by
DOLLARis specific to your spreadsheet locale.
DOLLARdiffers from the related function
DOLLARoutputs text rather than applying a cell format to a number.
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: