See John McGimpsey's site for info.

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


Gord Dibben MS Excel MVP

On Wed, 9 Sep 2009 15:40:01 -0700, Bzltyr
wrote:

I have a column of 4600 number that should equal zero as they are for
entering journal entries so they must balance to zero.
I have done functions: roundup, rounddown, trunc, mround, and the individual
cells show only two decimal pionts for example 4,120.33. when I add the
column it adds up to zero until I start expanding the zeros after the
decimal. When I get to about six places right of the decimal there is a
value. None of my numbers have any values beyond two decimal places.