When an input value starts with zero, Excel will delete the zero by default. Rather than resetting the Format Cells, this problem can be easily solved by adding a single quote mark ahead of the first zero, as shown.
Bio: Philonoist. Pursuer of Dreams. Travel Aficionado. Web & Market Researcher. Social Media Analyst. Achiever. Internet Junkie. Independent. Creative
Register For This Site