Skip to main content

DOLLAR function

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:

ArgumentDescription
numberAny number to convert.
decimalsA 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.

DOLLAR Function