The DOLLAR function converts a number to text, using a currency format. number is the number to be converted and formatted.
precision specifies how the number is to be rounded. For example, 2 will round the number to 2 decimal places, while -2 will round the number to 2 places to the left of the point. If precision is omitted the default currency precision is taken from Windows settings.
For example:
DOLLAR(234.19999, 2) returns "$234.20"
DOLLAR(234.19999, -2) returns "$200"
See also: