Question: have zero show in excel?
Answer: Click File > Options > Advanced.
Under Display options for this worksheet, select a worksheet, and then do one of the following: To display zero (0) values in cells, select the Show a zero in cells that have zero value check box.