I have multiple spreadsheet in a workbook with calculations of the top 10% of
employee by division within the company. I would like to create a macro to
round all those numbers to the nearest whole number so for example I don't
have 1.6 employees, rather I would show 2 employees.

Any suggestions?

Thanks so much!

TimN,

Do you need the value of the calculation to be rounded or can just the display value be rounded.

If all you need to *SEE* is a rounded value, then set the decimal places for that cell to zero. The calculated value will still be
1.6, but you will see 2.

If you need the calculated value to be rounded, then wrap the ROUND function around the current calculation. For example, if your
formula is something like:

=16/10
or
=A1/B1

Then your formula afterwards would be:

=ROUND(10/16,0)
or
=ROUND(A1/B1,0)

I hope this helps,

Conan Kelly



"TimN" wrote in message ...
I have multiple spreadsheet in a workbook with calculations of the top 10% of
employee by division within the company. I would like to create a macro to
round all those numbers to the nearest whole number so for example I don't
have 1.6 employees, rather I would show 2 employees.

Any suggestions?

Thanks so much!