display / print 0's in pivot table cells
 

have a pivot table with blank cells. people would like to have 0's in the
cells.
doable?

Select a cell in the pivot table
On the PivotTable toolbar, choose PivotTableTable Options
Check the box 'For empty cells, show'
In the text box, type a zero
Click OK


Mark wrote:
have a pivot table with blank cells. people would like to have 0's in the
cells.
doable?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html