Question: have leading zeros in excel?
Answer: Select a cell(s) where you want to show leading zeros, and press Ctrl+1 to open the Format Cells dialog.
Under Category, select Custom.
Type a format code in the Type box. ... 
Click OK to save the changes.