Rounding up a whole column of numbers

G

Guest

OKay, I figured out how to round up on number but what i want to do is round
a whole column of numbers. Say the number is .471 i want it to be .42 and i
want it to do that for the whole column. Any help?
 
G

Guest

2 questions down for me, here is what i wrote

Try this, select the entire column, right click, format cells, and set the
custom to ##.## this worked for me.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Round a whole column of numbers 3
rounding up to nearest specified whole number 1
Rounding up - number data and frequencies 2
Rounding up or down to nearest whole number 1
How to Round Whole Numbers? 3
Rounding numbers 4
How to stop excel from rounding ? 3
Excel 2007 - RoundDown in Calculation? 4

Top