ExcelBanter - Hiding 0 values in Pivot Table

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Hiding 0 values in Pivot Table (https://www.excelbanter.com/excel-programming/304836-hiding-0-values-pivot-table.html)

Bert[_4_]

Hiding 0 values in Pivot Table

I have a pivot table, how do I hide values of 0? I don't
want this data to show up in the pivot. Most of the data
is 0.

Thanks,

All times are GMT +1. The time now is 10:56 PM.