How To Force Microsoft Excel To Show Leading Zeroes

By default, Excel doesn’t show the leading zero in any non-decimal numerical data set. But if you need to show the leading zero — usually because of some weird numbering system at your job, it’s easy to keep that zero in its place.