This function converts a number to text using currency format, with the decimals rounded to the specified place.
DOLLAR(value,digits)
This function has these arguments:
| Argument | Description |
|---|---|
| value | Numeric value to convert to text using the currency format |
| digits | [Optional] Number of decimal places to maintain; if negative, the value is rounded to the left of the decimal point; if omitted, the function rounds to two decimal places |
This function uses the current regional Windows settings to determine the format of the returned string.
Accepts numeric data for both arguments. Returns string data.
DOLLAR(B5,D2)
DOLLAR(R5C2,R2C4)
DOLLAR(1234.5678,3) gives the result $1,234.568
DOLLAR(123.45,1) gives the result $123.5