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.