Rounding

[Corey]

Hello. I know the classic formula for rounding to zero
decimals:

ROUND(XX,0)

However, I want to apply this to a whole series of
existing numbers in 100+ cells. Is there a way to insert
the formula without manually adding it to each cell with
an existing number?

Any help is much appreciated!

Corey

 

[filky]

Why not use the cell format and do the whole column

 

[Corey]

Because the columns are being summed.

For Example:

16.68 + 86.81 = 103 when using the cell format to zero
decimals for the above three cells. Though, the cells
appear as: 17 + 87 = 103, it should equal 104 if truly
rounded to a whole number.

ROUND(16.68,0) + ROUND(86.81) = 104 when using the ROUND
formula. This works, but would be very time consuming to
enter into each cell.

There will always be decimals in these cells, but I want
them to only add rounded whole numbers. I'm off by 1 in
many places.

 

[filky]

Aha I see. There is a more drastic solution. Format your cells to zer
decimal places and then select Tool - Options - General - Precision a
displayed

This will correct all existing data on the spreadsheet as you want i
and also automaticaly edit any new numbers as you put them in

 

[Corey]

Excellent! Thank you very much!!

Corey