Description
Returns the specified number as text, using currency format and the supplied precision.
Syntax
DOLLAR ( number [, precision] )
| Parameter | Description |
|---|---|
| number | A number, a formula that evaluates to a number, or a reference to a cell that contains a number. |
| precision | A value representing the number of decimal places to the
right of the decimal point. Omitting this argument assumes the standard number of decimal places for the local currency. The default is 2. |
Note: "Local" currency refers to the currency format for the current system; that is, the format specified in Regional Settings in Control Panel
Remarks
Dollar will return the specified number format as text using currency format for the current system.
Examples
US Example
When using a US setting in Windows, this function returns $1023.79:
DOLLAR(1023.789)
This function returns $500:
DOLLAR(495.301, -2)
UK Example
When using a British setting in Windows, this function returns £1023.8:
DOLLAR(1023.789)
This function returns £500:
DOLLAR(495.301, -2)
European Example
When using a German setting in Windows, this function returns 1023,8 €:
DOLLAR(1023.789)
This function returns 500 €:
DOLLAR(495.30, 2)
Note: For information about rounding, see the ROUND function.
See also