Using a custom number format to display leading .
· In Microsoft Excel, you can use either of two methods for using a custom number format to display leading zeros. Use one method for fixedlength numbers and use the other method for variablelength numbers. Method 1: Fixedlength Numbers When you want to display leading zeros for a fixedlength number, create a custom format with the same number of zeros (0) as digits that you want to .