Thread: =SUM returns 5.54365E-11 instead of 0 (zero)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chwan Keng Ng Chwan Keng Ng is offline
external usenet poster
  
Posts: 2
Default =SUM returns 5.54365E-11 instead of 0 (zero)
I have a set of journal data extracted from SQL Server 2005 and paste them
in Excel 2003, the net result of this set of number should produce 0,
instead in the cell that I use the =SUM() function, it produced
"5.54365E-11"
How come?
I could format the cell using "Number" which gaved me "0" but I am just
wondering why?






Reply With QuoteReply With Quote