Accounting format | Message 1 of 12 | TechRepublic

Discussion on:

Three ways to hide zero values in an Excel sheet

View entire thread

Message 1 of 12

Next »

4 Votes

+ -

Accounting format

While it doesn't remove the 0, using the Accounting format with no Symbol. This then shows a "-" instead of a zero. I use this to clean up the sheet very easily.

Posted by hometoy

21st Jun