Question: excel if zero do not display?
Answer: Click the File menu and then choose Options (under Help). ...  Choose Advanced in the left pane. ...  In the Display Options For This Worksheet section, uncheck the Show A Zero In Cells That Have Zero Value. Click OK.