Friday, 22 April 2022

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

No comments :

Post a Comment

Thanks for your feedback. The elves will post it shortly.