Converts a number into a text string with a currency symbol, thousands commas and with a number of decimal places.
Syntax:
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.
If digits is omitted, the default number of decimal places is two.
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"
.
Revisions:
This function was added in 2.00.