Pivot Table Suppression

[Gaffnr]

Hi All
Ive created simple a pivot table in Excel 2003 that sums by values.
Does anybody know how to suppress these zero values so I only see postive or
negative values in my table?

Thanks
Rob

 

[Roger Govier]

Hi Rob

Tools>Options>remove check mark from Zero Values