Breadcrumbs

DOLLAR

Definition

Formats a number into the locale-specific currency format.

Sample Usage

DOLLAR(1.2351,4)

DOLLAR(2.35)

Syntax

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.

Notes

  • 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:

DOLLAR_1.png

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

DOLLAR_2.png

DOLLAR_3.png

DOLLAR_5.png

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

DOLLAR_4.png

DOLLAR_6.png

 

There were errors rendering macro:

  • An unknown error occurred.