Help with Pivot Tables

[lk26]

Hi,

I have a Spreadsheet and within it there is a column with dates and some cells are blank. when i make a pivot table with this spreadsheet, the blank cells show up with "(blank)" in them. Can I tell it not to put the "(blank)" in the cells and just actually be a blank cell?

Sincerely,

Lauretta

[dilipandey]

Hi Lauretta,


I guess there is an option in Pivot -> Pivot table options - > For empty value show = _______

post the sample file if you still have issues. thanks.

regards,
DILIPandey

<click on below 'star' if this helps>