I want to stop Excel from dropping the leading zero, permanently and forever. I know I can format as text and or put in some special number formatting, but the data I work with this quickly becomes a pain. I just want Excel to retain those leading zeros, surely there is a way, an option somewhere that can be changed.

Thanks ahead of time for any help you guys can give me.