You could just type over that cell with (blank) in it. (Use a single space???)

If you have trouble, maybe using Debra Dalgleish's pivottable addin would
help--besides, there's lots of other stuff in that addin that you may like:

http://www.contextures.com/xlPivotAddIn02.html

Marilyn wrote:

Hello one of my columns in the pivot table shows "blank" as the result.
I do not want the word blank I want a nothing on the cell. How isthis done?
thanks

--

Dave Peterson