In this learn excel post, we will see how we can put 0 before any number in excel.
You have observed that whenever you try to put 0 before any number in excel, It removes the 0. In this post, we will see how we can able to put zero (0) before any number in excel.
By Making cell format into Text we can able to put 0 before the number in excel.
To put 0, you have to change the cell format You can open the cell format by pressing the
ctrl +1 key OR You can right-click on the cell and select cell format and change it to Text.