DOLLAR


Description Returns the specified number as text, using the local currency format and the supplied precision.

Syntax DOLLAR ( number [, precision] )
Argument Description
number A number, a formula that evaluates to a number, or a reference to a cell that contains a number.
[precision] Optional. A value representing the number of decimal places to the right of the decimal point. If this argument is omitted, 2 is used.

Note "Local" currency refers to the currency format for the current system.

Remarks Dollar will return the specified number format as text using currency format for the current system. If you wish to always convert to the US Dollar format, regardless of the language of your system, then use the USDOLLAR worksheet function.

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)

German Example When using a German setting in Windows, this function returns 1023,8 DM

DOLLAR(1023.789)

This function returns 500 DM:

DOLLAR(495.301, -2)

See Also FIXED, TEXT, VALUE, USDOLLAR