pivot tables show zeros
 

I have a great povit table however, I would like to have a 0 (Zero) to show
were there is no value.

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

Povit tables I mean. I know I have do this in the past Looking in the format
area.

"sueanne" wrote:

I have a great povit table however, I would like to have a 0 (Zero) to show
were there is no value.

Thank you dear person.
I can go home.

"Debra Dalgleish" wrote:

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

pivot tables show zeros
 

Debra
Would this then apply to all spreadsheets or only the one that was open when
this was done?
Steve

"Debra Dalgleish" wrote:

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

pivot tables show zeros
 

Steve, the option is set for that PivotTable only. If you have another
PivotTable, you need to set up that option again.
--
Some day I''''ll be the most powerful Jedi ever.


"Steve" wrote:

Debra
Would this then apply to all spreadsheets or only the one that was open when
this was done?
Steve

"Debra Dalgleish" wrote:

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