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).

techman41973@yahoo.com 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