Prev: Saving file
Next: draw corners
From: Barb Reinhardt on 10 Mar 2010 09:19
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

From: Pete_UK on 10 Mar 2010 10:00
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
<BarbReinha...(a)discussions.microsoft.com> 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

From: AdamV on 12 Mar 2010 10:29
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
>
 | 
Pages: 1
Prev: Saving file
Next: draw corners