DOLLAR(number, precision)

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:

Other text functions