Round a whole column of numbers
 

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?

Round a whole column of numbers
 

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?

Round a whole column of numbers
 

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.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"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?

Round a whole column of numbers
 

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?