Question: have zero in front of number excel?
Answer: Select the range of mobile numbers., And press the key “CTRL+1” on the keyboard., The “Format Cells” dialog box will appear.., In the “Number” tab select “Custom” from the list., In the “Type” box write 0 eleven times., Click on ok.