Excel2007 Summary on more decimal data incorrect result

[akit3210]

On Excel 2007

I'm extract data from oracle and summary data
(I'm set it show more decimal cause found some problem about calculate in my delphi application)
and found result is incorrect with additional 0.00000001000

I'm try to find out problem and not to know
Please let me khow what happen.

Please see in attach file.sum_decimal_problem.xlsx

Thank you very much.

[Glenn Kennedy]

The silly answer to this is "Excel can't count". However, there is a slightly more sensible answer to this. Panic not - it is a real thing in Excel and not something daft that you have done. Take a look at this article by Microsoft:

http://support.microsoft.com/kb/78113

[Kaper]

699,213.200000001000
come from rounding and a way excel stores numbers with 15 significant digits
have a look on Microsoft explanation support.microsoft.com/kb/78113

[akit3210]

Thank you very much
Glenn Kennedy and Kaper.

I will inform our developer about this data is correct since it stay on Oracle Database.
But problem from summary on Excel.

Best regards,