DOLLAR

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 2.00.