I am sure some of you have faced this problem of entering a number like “023423423” in an excel sheet and it will automatically change to “23423423”. The zero goes of automatically. What to be done? In fact the cell takes this as number and removes the zero prefix. So you need to tell the cell that its not number but a text.

First you need to edit the cell properties, but pressing the ctrl + 1 key and in the number tab, select text

Click ok and you will find that the number is the same that you have typed