Create Or Delete Custom Number Format. Select the cells you want to format. Add leading zeros to a number.
Doing that will enable the Reset button which you use to remove the customization. The Define New Number Format dialog box opens. Any cells in your table that use the deleted format revert to Automatic formatting.
First up hit Ctrl 1 to open up the Format Cells dialog box.
Type what you want in quotation marks. Add leading zeros to a number. Select cell s with values you want to format Control 1 Numbers Custom Enter codes and watch preview area to see result Press OK to save and apply. Click Edit Custom Format then do one of the following.