Read: How to add Text to a Cell in Excel using Formula? How do I open Excel without losing leading zeros? If you are trying to import an existing Excel file to your workbook without removing ...

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.

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.