If you realized, you cannot insert number “00”, “000000” in the Microsoft Excel. Every time you insert the number 00 in the Excel box, the number will be only 0 (even you insert thousands of 0’s). This is also affected, when you insert number 0 before any number, let say, you are inserting 012345. The excel will read only 12345 with no 0.
Solution
Right click on the field box. Select Format Cells. Under Number tab, choose Text and press Enter. You can now insert the number 000.
