See

http://www.mcgimpsey.com/excel/pennyoff.html

for an explanation

--
Regards,

Peo Sjoblom


"
crosoft.com wrote in
message ...
We use a column of numbers and divide each one by the total to see the %
each
one should be allocated in other formulas. The sum total should add to
100%
and it does in the sum cell. However, when using for other purposes, the
column does not add up. It appears the system retains the numbers to an
Nth
decimal that do add; when displaying less decimals, a rounded number, they
do
not add to the total. When using a rounded number for further
calculations,
the answer is off also.