This is because Excel sees the zeros as insignificant number and as a result drops them.Zero is an even number neither positive nor negative number or both positive or negative.
We can do this by converting a cell to a text cell. To add a zero, click into the cell infront of the number then press Apostrophe key(') and add so many zeros as you want.In this way you can add zero before number and Excel will treat as a text.
There are following to add 0 in the blank cell.
First select the empty cell.
Press F2 to enter a value in the active cell.
Type any number or text you want to enter.
In the last press Ctrl+Enter.
so, in this method you can add 0 to blank cell in the Excel.
Therefore,To display zero (0) values in a cells. Check the show zero in the cell that have zero value checkbox.
To learn more about zero visit;
https://brainly.com/question/28146711
#SPJ4