Skip to main content

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:

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:

 

A
B
1
Data
2
1234.567
3
1234.567
4
5
Displays the number in A2 in currency format, 2 digits to the right of the decimal point:
¤1,234.57
6
7
Displays the number in A2 in currency format, 2 digits to the left of the decimal point:
¤1,200

JavaScript errors detected

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

If this problem persists, please contact our support.

Contact Support Close