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.