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.

Is it frustrating that the leading zeros are automatically removed from your Excel workbook? Excel typically removes the leading zeros before a number as you input the number in a cell. It treats cell ...