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?

Answered in previous post
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Dabbles" wrote:

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?

which post?

"John Bundy" wrote:

Answered in previous post
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Dabbles" wrote:

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?

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.

--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Dabbles" wrote:

which post?

"John Bundy" wrote:

Answered in previous post
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Dabbles" wrote:

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?

That changed .471 to .42 ?

How so?


Gord Dibben MS Excel MVP

On Tue, 31 Jul 2007 13:30:05 -0700, John Bundy (remove)
wrote:

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.