Yet when I =SUM(E1:E763) I get the total of -0.000000000002501104298755.

You are the dictator of 250 000 people. Each one of them (happily) pay you
this amount of dollars every minute, day and night, all year through.

After X time you can buy a hot dog with your tax money.

X is ?

Question / problem is ?

Best wishes Harald

"Chuck" wrote in message
...
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.