ExcelBanter - Pivot Tables - "(blank)" in rows and cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot Tables - "(blank)" in rows and cells (https://www.excelbanter.com/excel-discussion-misc-queries/123227-pivot-tables-blank-rows-cells.html)

Peterp

Pivot Tables - "(blank)" in rows and cells

Hi All
Is there perhaps a way of suppressing the rather irritating word "(blank)"
in cells and rows in Pivot Tables without entering a zero in the spread
sheet.
Best Regards
Peter

All times are GMT +1. The time now is 10:19 AM.