I'm obviously missing something? Why =ROUND(A22/0.01,0)*0.01 and not
=ROUND(A22,2), Sandy?
--
David Biddulph

"Sandy Mann" wrote in message
...
If you just want to display the number to 2 decimal places then use John's
solution but note that just changing the formatting will leave the full
number in the cell not a rounded number.

If you want to actually change the number to only the number rounded to
the nearest 0.01 then I would use a helper column and enter the formula:

=ROUND(A22/0.01,0)*0.01

and copy down using the fill handle and then copy and Paste Special onto
the original data and then delete the helper column.

"Dabbles" wrote in message
...
I figured out how to round one number to the nearest .01 but i need to do
that to a whole column of numbers. Say the number is .4178, i want it to
be
.42 and i want to do that to the whole column. Any help?