Division in a column in excel.

[ChrisB]

How do I divide an entire column by a specific number? Furthermore, is
it possible to round those numbers so I dont get "4.758" for example,
and can it overlook text in the same column on certain cells ?

 

[Jason Lepack]

You mean like this?

Assuming the numbers you want to divide are in Column A, place this
formula in B1 and fill down.

I don't know why you would want to have text in column with a bunch of
numbers in the first place, but this should do the trick. If it
doesn't, post back.

=IF(ISERROR(ROUND(A1/2,0)),"",ROUND(A1/2,0))

Cheers,
Jason Lepack

 

[ChrisB]

worked like a charm, thanks alot