I just spent several hours trying to reconcile an Exel spreadsheet against
data from my accouting software only to discover that Excel is miscalculation
a simple formula. I have a column of dollar figures in cells formatted as
currency. If I use autosum, the formula reads:

=SUM(A1:A39)

and the total is $6447.60

But if I create the following formula:

=A1+A2+A3....etc to A39

the total is $6684.73, which is correct. (The difference is $237.13)

I have no hidden rows and have tried copying all the number into a new
spreadsheet. Can someone tell me what's going on here? Thanks.