View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
dlw dlw is offline
external usenet poster
 
Posts: 510
Default Sum show difference of -0.000000000002501104298755

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.