DOLLAR
Converts a number to text using the $ (dollar) currency format
Syntax
DOLLAR(number, [decimals])
Parameters
- number: Required. A number, a reference to a cell containing a number, or a formula that evaluates to a number
- decimals: Optional. The number of digits to the right of the decimal point (default 2)
Example
=DOLLAR(1234.567, 2)