Here are Three Different Ways to Handle this Type of Situation:
1. Place an apostrophe (AKA a tick mark) initially, and then add the leading zero.
2. Format Cells by selecting Custom/Type: Choose 10 zeros (if you have, for example,10-digit account numbers) and hit Okay.
3. The third method (I recommend this for most cases…) is to format the cell range as Text. This automatically corrects this potentially annoying problem.
That’s all there is to it! The next time you want to keep your Leading Zeros, remember these simple tricks.