The problem with rounding numbers with the INT function is that if you
try and use them then for another function it uses the integer instead
of the underlying number.

I have found that a great solution to this problem is to have your
calculations performed on a separate sheet, with all of the decimals
that you need.

Then set up another sheet just like it that displays all of the data
from the cells using the INT function. This way your equations
maintain their accuracy while the sheet that you are viewing is clean
and easy to read.


--
gerberdude
------------------------------------------------------------------------
gerberdude's Profile: http://www.excelforum.com/member.php...o&userid=30754
View this thread: http://www.excelforum.com/showthread...hreadid=496935