Sunday, January 11, 2015

Zero 0

Zero is nothing


If a zero isn't worth anything, why show it?

Here is a Microsoft tutorial about how to deal with zilch:


  • Display or hide all zero values on a worksheet

  • Use a number format to hide zero values in selected cells

  • Use a conditional format to hide zero values returned by a formula

  • Use a formula to display zeros as a blanks or dashes

  • Hide zero values in a PivotTable report
Hide Zeros



See all Topics

No comments: