After seeing the result, your boss now wants to hide the zeroes.
This is where developing our own custom number formatting comes into the picture.
Start by pressing CTRL-1 on your keyboard (or right-click “Format Cells…”) to access the Format Cells dialog box.
From here, we will select the Number tab at the top and then select the Category: Custom on the left.
We can see the format codes for the original thousands separator format we first applied.
We will update the codes in the “Type:” field to read:
Our zero values are now gone.
Before we break down the logic of the custom number format, we need to ask ourselves, “Are the zero values really gone?”
If we select an “empty” cell where a zero once was, we can see in the Formula Bar that the zero is still in the cell.
The key to remember about number formatting is that the formatting never actually changes the data; it merely alters the way it is presented to the user. (There are exceptions to this, such as the Percent Style.)
The number remains as it was typed. Think of number formatting as a costume that allows the number to pretend to be something different than what it is.
In this case, the custom rule hides the zeroes.