How to clear the word '(blank)' from a cell in a Pivot Table
 

When a source cell in Excel is empty my Pivot Table comes up with the word
'(blank)' in the cell. How can I hide this word so the cell still appears
but with no text in it in my Pivot Table?

How to clear the word '(blank)' from a cell in a Pivot Table
 

Select one of the (blank) cells in the pivot table, and type a space
character, then press the Enter key to complete the change.

Rob Conder wrote:
When a source cell in Excel is empty my Pivot Table comes up with the word
'(blank)' in the cell. How can I hide this word so the cell still appears
but with no text in it in my Pivot Table?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

How to clear the word '(blank)' from a cell in a Pivot Table
 

This is a Cell Format issue that can be resolved by using an IF statement
(see display or hide zero values in Help) or by using a Custom Cell Format
(pick any cell in your sheet and se lect Format Cells Custom and use the help
index to learn what all the little notations mean and copy this new cell
form,at that you create yourself into all the cells where '(blank)' might
occur.
--
big-bob


"Rob Conder" wrote:

When a source cell in Excel is empty my Pivot Table comes up with the word
'(blank)' in the cell. How can I hide this word so the cell still appears
but with no text in it in my Pivot Table?