Does anyone know how to format this.

If I have in one cell $21.40 and I have another cell I'm comparing that cell
to to give me a result that has $21.3980506 in the cell. My question will not
say they match because of the string of #'s after the .39. I need to change
all the cells in that column to be only 4 digits and rounding up if necessary.

Does anyone know an easy way to do this?

Thanks, B.

=ROUND(A1,2)

where A1=21.3980506

"BSantos" wrote:

Does anyone know how to format this.

If I have in one cell $21.40 and I have another cell I'm comparing that cell
to to give me a result that has $21.3980506 in the cell. My question will not
say they match because of the string of #'s after the .39. I need to change
all the cells in that column to be only 4 digits and rounding up if necessary.

Does anyone know an easy way to do this?

Thanks, B.