Wow, and who said computer guys were geeks, this could be auditions for the
comedy channel.
FYI, the query in Access that creates the spreadsheet has Round(x,2) for the
column.
Then I tried =Round(E2,2) on the spreadsheet for all the rows and still get
the hot dog in 3 years, which of course I'll share with my 250,000 subjects.

"dlw" wrote:

in 10 years you'll have $3.29 (rounded, of course)
unless my Excel is wrong... :)

"Harald Staff" wrote:

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.