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

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

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