display / print 0's in pivot table cells

[Mark]

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

[MattShoreson]

yep.

right-click the table.
Select table options.

where you have for empty cells display nothing.
Put in a 0.

[Debra Dalgleish]

Select a cell in the pivot table
On the PivotTable toolbar, choose PivotTable>Table 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