How do you allow zeros in front of numbers in Excel? There are different methods to keep the leading zeros in a number in an Excel workbook.

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.

You can add a zero before a number in Google Sheets and Excel using this tutorial. You need to change cell formatting or use function.