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

[Guest]

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]

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

 

[Guest]

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.