See http://www.cpearson.com/excel/rounding.htm for an excellent article on
the subject...

"Chuck" wrote:

The spreadsheet was created from an Access query where the column is defined
as double with 2 decimil places.
In Excel I expand the column to 30 decimal places and none of the values
have anything but 0 past the second decimal place.
Yet when I =SUM(E1:E763) I get the total of -0.000000000002501104298755.
I have tried changing the format in Excel to currency, general, accounting,
no change?
Any ideas would be appreciated.