Hiding Zeros in Excel

Sometimes when working with Excel, we want to hide zeroes; particularly when working across multiple spreadsheets, with formulae.

It is surprisingly difficult to find out how to do this!

However, there is a wee number code which we can enter as a custom number type in Excel:

0;-0;;@

That format details what we have to specify in Excel as a custom format structure: what the format should do with positive numbers (as a number); then with negative numbers (as a minus number); then what it should do with zeros (ignore them); then, lastly, what it should do with text (show it as written).

So easy when we know how!

Sam