Converts a number into a text string with a currency symbol, thousands commas and with a number of decimal places.
DOLLAR(number {, digits:number})
Returns the text string given by converting number to text with a currency symbol, thousands commas and with digits decimal places.
Rounding is carried out according to the same formula as that used by the ROUND
function.
Example:
DOLLAR(123456.789, 2)
returns the text string "£123,456.79"
.
Added in 1.36.