Guide: How to remove automatic leading zeroes in Excel

Windows

1. In Excel, click on File > Options
2. In the Data tab on the left, under the heading Automatic Data Conversion, uncheck the Remove leading zeros and cover to a number setting