B Barb Reinhardt Mar 10, 2010 #1 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
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
P Pete_UK Mar 10, 2010 #2 You can use conditional formatting to set the foreground colour to white if the cell contents are zero. Hope this helps. Pete
You can use conditional formatting to set the foreground colour to white if the cell contents are zero. Hope this helps. Pete
A AdamV Mar 12, 2010 #3 Change the number format to suppress them using, for example: General;General;;@ as a custom format. Hope this helps Adam
Change the number format to suppress them using, for example: General;General;;@ as a custom format. Hope this helps Adam
