Question: excel if zero do not show?
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.