When you input a number in an excel cell and if the number needs to start with 0, you will find excel will remove all the zeros at the beginning of the number. In this article, I will tell you how to put 0 in excel in front of numbers with several methods.

### 1. Use Apostrophe To Put 0 In Excel In Front Of Numbers.

- Input the number
**001**in cell**A1**. - When you press the enter key, it will display the number
**1**in cell**A1**. - If you want to reserve the 2 zeros before the number 1, you should first input the apostrophe character (
**‘**) before**0**. - Now input the text
**‘001**in cell**A1**. - When you press the enter key now, it will display the number
**001**in cell**A1**also.

### 2. Format Cells To Put 0 Before Numbers In Excel.

- If you have multiple numbers in an excel column like below, and you want to put a fixed number of 0 in front of each number, you can use the format cell feature.

123 1391 969696 - Select all the above number cells, right-click them and click the
**Format Cells…**item in the popup menu list. - In the popup
**Format Cells**dialog, click the**Number**Â tab. - Click the
**Custom**item in the**Category**list. - Input the text
**000###**Â in the**Type**input box on the right side. - Click the
**OK**button to save the changes. - Now you can see the numbers have been changed as below.

000123 001391 969696 - You will find that it does not add 0 in front of each number, this is because the total number of digits in the cell format text is 6 (
**000###**). - So if the original number contains less than 6 digits, it will add the related zeros in front of the original number.
- If the original number contains more than 6 digits, it will display the original number.
- So to put a fixed number of 0 in front of all the numbers, you should use the custom cell text format
**000######**in this example. - Then you will get the below cell data.

000123 0001391 000969696

### 3. How To Put 0 In Excel In Front Of Numbers To Make All The Numbers The Same Length.

- In the above example, the result number’s length is not the same after adding the zeros before the number.
- Now I will tell you how to make the numbers the same length after adding zeros before the number.
- Select the number column, right-click it and click the
**Format Cells…**menu item in the popup menu list. - Select the
**Custom**item in the**Number**tab**Category**list. - Then input the text format
**000000000**in the**Type**input box on the dialog right side. - Click the
**OK**button to save it. - Then you will get the below cell data, you can see all the numbers are the same length and start with zeros.

000000123 000001391 000969696

### 4. How To Use Formula To Add Fixed Number Of 0 In Front Of Number.

- We can also use an excel formula to add a fixed number of 0 in front of numbers, below is the example data cells.

**A****B****1**123 **2**1391 **3**969696 - Input the formula
**=IF(ISNUMBER(A1)=TRUE,”000″&A1,””)Â**in cell**B1**. - When you press the enter key, it will display the number
**000123**in cell**B1**. - Select cell
**B1**and drag down the small cross icon on the bottom right corner of cell**B1**to cell**B3**. - Then it will autofill the formula to all the 3 excel cells.
- Then you will get the below data cells.

123 000123 1391 0001391 969696 000969696

### 5. How To Use Excel Formula To Add 0 In Front Of Number And Make The Result Number The Same Length.

- You can also use an excel formula to add 0 in front of numbers and make the resulting number the same length.
- Input the formula
**=TEXT(A1,”000000000″)**in cell**B1**. - Then autofill the formula to cell range
**B1:B3**, then you will get the below data cells.

123 000000123 1391 000001391 969696 000969696