When enter zero in the cell, Excel will show zero in the cell, but if the feature disappeared and you want it back, please follow the steps below:
Step 1: Click the "File" Tab from the ribbon;
Step 2: Click "Options" from the left navigation menu;
Step 3: Click "Advanced" from the left navigation menu in the dialog box;
Step 4: Check the box of "Show a zero in cells that have zero value" under the section of "Display options for this worksheet";
Step 5: Click "OK" at the bottom.
