Try this, select the entire column, right click, format cells, and set the
custom to ##.## this worked for me.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Dabbles" wrote:

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?