You can change the caption:

In the pivot table, select one of the cells that says (Blank)
Type a space character
Press Enter

dipsy wrote:
When I create a pivot table - there is a column included with "Comments".
Where ever there are no comments in the data table - the pivot table has
"(blank)". For items that have no data I want to just show a blank.

In Pivot Table Options - for empty cells - I put in a space and yet I keep
seeing text - blank.

Thanks in advance for the help.


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