View Single Post
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

Select the cell that contains (blank), and type a space character.

Or, if you don't want to include the data for blanks, click the dropdown
arrow on the field heading, and remove the check mark from (blank).

wrote:
I generated a pivot table in an excel spreadsheet.
Is there any way to instruct excel not to show the word (blank) in
blank cells?
Thanks



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html