Right-click on a cell in the pivot table
Choose Table Options
Check the box for 'For empty cells show'
In the box, type a zero
Click OK
sueanne wrote:
I have a great povit table however, I would like to have a 0 (Zero) to show
were there is no value.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html