Cell Formating

[Guest]

I am using Excel 2003.

I want to know how to round a whole column of data without using the
ROUND(cell,0) formula for each cell in a new column to use the ROUND function
to achieve what I want.
I have data that has decimal places to 10 or more places when it is imported
from different software programs I use; one is from Access.

Thanks for your help,
Curt

 

[Guest]

Format > Cells... > Number and set the number of decimal places to zero.

 

[David Biddulph]

If you've got such a dislike of the ROUND() function you can format the
original column as number with zero decimal places. If you want to actually
change the values you can use Tools/ Options/ Calculation/ Precision as
displayed.

 

[Guest]

Thank you.
This is what I was looking for.

Curt

If you've got such a dislike of the ROUND() function you can format the
original column as number with zero decimal places. If you want to actually
change the values you can use Tools/ Options/ Calculation/ Precision as
displayed.