Hi,
Select the pivot table and choose PivotTable, Table Options, check For empty
cells, show and then leave the box after it empty.
Or turn off the 0's for the entire sheet using Tools, Options, View, and
uncheck Zero Values.
--
Cheers,
Shane Devenshire
"Jelinek" wrote:
[Quoted Text] > Is there away to surpess 0 on pivot tables?
|