Concatenates a text-expressions into a single text value. Numbers are converted to text as needed.
Syntax
DOLLAR(number,{decimals})
Arguments
number Number to convert to currency formatted text. decimals Number of decimal places to show. (If omitted, the default is 2.) Example
DOLLAR(1000,1) returns $1,000.0