S
sueanne
I have a great povit table however, I would like to have a 0 (Zero) to show
were there is no value.
were there is no value.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Debra Dalgleish
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
Choose Table Options
Check the box for 'For empty cells show'
In the box, type a zero
Click OK
S
sueanne
Povit tables I mean. I know I have do this in the past Looking in the format
area.
area.
S
sueanne
Thank you dear person.
I can go home.
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
S
Steve
Debra
Would this then apply to all spreadsheets or only the one that was open when
this was done?
Steve
Would this then apply to all spreadsheets or only the one that was open when
this was done?
Steve
S
Skywalker
Steve, the option is set for that PivotTable only. If you have another
PivotTable, you need to set up that option again.
PivotTable, you need to set up that option again.