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 ...

Excel typically removes the leading zeros before a number as you input the number ... an existing Excel file to your workbook without removing leading zeros, go to the Data tab and click on ...