DOLLAR function returns the number provided as text. Numbers stored as text are a common cause of spreadsheet errors, because many functions ignore them, such as SUM, AVERAGE, MIN, MAX, etc.
=dollar(number,decimal values)
=dollar(A1,2)
The DOLLAR function syntax has the following arguments:
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. If this is negative, the number is rounded to the left of the decimal point. If you omit decimals, it is assumed to be 2.
