View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AdamV[_2_] AdamV[_2_] is offline
external usenet poster
 
Posts: 38
Default Excel 2007 Pivot Tables - do not display zero values

Change the number format to suppress them using, for example:

General;General;;@

as a custom format.

Hope this helps
Adam

On 10/03/2010 14:19, Barb Reinhardt wrote:
How do I set my pivot table so that it does not display any sums of values
that are equal to zero?

Thanks,

Barb Reinhardt