G Guest Mar 1, 2005 #1 I have a great povit table however, I would like to have a 0 (Zero) to show were there is no value.
D Debra Dalgleish Mar 1, 2005 #2 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
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
G Guest Mar 1, 2005 #3 Povit tables I mean. I know I have do this in the past Looking in the format area.
G Guest Mar 1, 2005 #4 Thank you dear person. I can go home. Debra Dalgleish said: 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 Click to expand...
Thank you dear person. I can go home. Debra Dalgleish said: 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 Click to expand...
G Guest Sep 25, 2007 #5 Debra Would this then apply to all spreadsheets or only the one that was open when this was done? Steve
Debra Would this then apply to all spreadsheets or only the one that was open when this was done? Steve
S Skywalker Jun 8, 2009 #6 Steve, the option is set for that PivotTable only. If you have another PivotTable, you need to set up that option again.
Steve, the option is set for that PivotTable only. If you have another PivotTable, you need to set up that option again.
