Is it frustrating that the leading zeros are automatically removed from your Excel workbook? Excel typically removes the leading zeros before a number as you input the number in a cell.

By placing a zero before the decimal, the number is more readily recognized as less than one. By configuring a custom number format you can tell Excel to remove leading zeros. How to Stop Apps ...

For instance, Excel will strip leading zeros from numbers and dates because they are not mathematically significant. You can keep the leading zeros in CSV files by using Excel's Text Import Wizard.