how to add zero before number in excel

Select the cell in which you want to add zeros as a prefix. Right ➜ Format Option or you can also use the shortcut key Ctrl + 1 open “Format Cell Dialog Box”. In Category ➜ Select Custom. In the custom input dialog box, enter “0000000”. OK.