The DOLLAR function is one of the text and data functions. Is used to convert a number to text, using a currency format $#.##.
Syntax
DOLLAR(number, [decimals])
The DOLLAR function has the following arguments:
Argument | Description |
---|
number | Any number to convert. |
decimals | A number of decimal places to display. If it is omitted, the function will assume it to be 2. |
Notes
How to apply the DOLLAR function.
Examples
The figure below displays the result returned by the DOLLAR function.
