Best 5 Top Adding Zero before serial number in excel

 Hi suppose you are adding serial number any list and you want to add Zero you can add easily in ms office excel more formula see example :-

1. First Example for adding zero before Number Now.

Example :- =REPT(0,2-LEN(E2))&E2  Enter

2.  Second Example for adding zero before Number see Now.

Example :- =TEXT(E2,"00") Enter

    

3.  Third Example for adding zero before Number see Now.

Example :- =CONCATENATE("00",E2) Enter

4.  Fourth Example for adding zero before Number see Now.

Example :- =REPT(0,2-LEN(E2))&E2 Enter

    

5. Fifth Example for adding zero before Number see Now.

Example:- Step First Select to cell range where you want to Add Zero in serial number 

Second Step :- Then Right click -> Then click on FORMAT CELL-> Then click on Text option -> OK

First Step:-

Second Step:-

Third Step :-