Excel 2007 Pivot Tables - do not display zero values
 

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

Excel 2007 Pivot Tables - do not display zero values
 

You can use conditional formatting to set the foreground colour to
white if the cell contents are zero.

Hope this helps.

Pete

On Mar 10, 2:19*pm, 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

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