Sponsored Link
Purpose
Convert a number to text in currency format
Return value
A number as text in currency format.
Syntax
=DOLLAR (number, decimals)
Arguments
- number – The number to convert.
- decimals – The number of digits to the right of the decimal point. Default is 2.
Usage notes
The DOLLAR function converts a number to text using currency number format. The number format used is $#,##0.00_);($#,##0.00).
The default for decimals is 2. If decimals is negative, number will be rounded to the left of the decimal point.
The TEXT function is a more flexible way to achieve the same result, since it can convert numbers to text in currency format and other number formats as well.
The name of the function and the currency symbol used is based on language settings of the computer.