Pivot Table - Sum is incorrect

[Fez87]

Hello,

I’ve got a large set of date which I’m using a Pivot Table to analyse.

I know that the sum of some of it equates to 0. The Pivot Table also displays 0, yet when I click on the cell and look in the formula bar it says -1.1990778-08 (it goes on many more numbers). There are other 0 figures in this column which do not behave in such manner. I’ve formatted the whole column to display as numbers. I’m at a loss as to why it’s behaving in such way as when I want to apply a further filter to my Pivot Table of 0 items it is being excluded in error.

appreciate any help! Thanks

 

[sandy666]

check your source data against text,
this is a text because : -1.1990778-08