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.

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.

Here are the multiple methods using which you can keep the leading zeros that are automatically omitted before a number in an Excel workbook.

You can remove leading, trailing, and extra spaces between characters and numbers in Excel using TRIM(), SUBSTITUTE() or Find and Replace.