While working with various numbers in **Excel**, sometimes it is necessary to add a ** 0** or

**at the beginning of the numbers. But by default, Excel will not keep the leading**

*00***or**

*0***after inputting the numbers with such conditions. So, this characteristic of**

*00***Excel**can cause problems while working. In this article, we will show you how to write

**in**

*00***Excel**.

**Table of Contents**hide

## Download Practice Workbook

You can download the free **Excel** workbook here and practice on your own.

## 11 Easy Ways to Write 00 in Excel

Sometimes, users have to input phone numbers, zip codes, employee identity numbers, etc., into **Excel**. Naturally, these numbers can have **00** in front of them. As a result, users cannot automatically input these numbers with ** 00** in

**Excel**. So, in this article, we will show you eleven different methods to write

**in**

*00***Excel**. For our working purposes, we will use the following data set.

To write ** 00** in

**Excel**, we will use symbols like an apostrophe and an ampersand. We will also change the cell format to text and add a custom cell format. Again, we will insert some

**Excel**functions like

**,**

*the CONCAT function***,**

*the RIGHT function***,**

*the TEXT function***,**

*the TEXTJOIN function***, and**

*the BASE function***. Finally, we will apply a**

*the REPT function***VBA**code to write

**in**

*00***Excel**.

### 1. Adding Apostrophe to Write 00 in Excel

In our first method, we will add an apostrophe (‘) before our number to write ** 00**. Let’s see the following steps for a better understanding.

**Step 1:**

- First of all, in our Output column, type an apostrophe (‘).
- Then, type
and, after that type the required number.*00*

**Step 2:**

- Secondly, press
after typing.*Enter* - Here, you will see the leading
before the number.*00* - This process transforms the number into text so the
won’t disappear after entering.*00*

**Step 3:**

- Finally, repeat the above steps for the following cells to write
.*00*

**Read More:** **How to Add Leading Zeros in Excel (4 Quick Methods)**

### 2. Including Ampersand (&) Operator to Write 00 in Excel

You can also write 00 before a number using the ampersand (&) operator. See the below-given steps for this procedure.

**Step 1:**

- First of all, type the following formula in cell
.*B5*

`="00"&B5`

**Step 2:**

- Secondly, press
to see the desired result.*Enter*

**Step 3:**

- Thirdly, use the
feature to drag the formula to the lower cells of the data set.*AutoFill* - Finally, you will see
before all the numbers.*00*

### 3. Using Custom Number Format to Write 00 in Excel

You can use a custom number format for your data set to write** 00** before them. Below are the detailed steps of this procedure.

**Step 1:**

- Firstly, select a cell where you want to see the desired output.

**Step 2:**

- Secondly, right-click on the cell and select the
command.*Format Cells…*

**Step 3:**

- Thirdly, you will see the
dialogue box.*Format Cells* - Then, go to the
tab.*Custom*

**Step 4:**

- Fourthly, in the
box type*Type*.*00* - Then, type a number of
which is equal to the digits of your number.*#* - For instance,
is a one-digit number.*5* - So, we will type a single
.*#* - Lastly, press
.*OK*

**Step 5:**

- Fifthly, in cell
type the number*C5*.*5*

**Step 6:**

- Then, after pressing Enter, you will see the
before the number.*00*

**Step 7:**

- Finally, customize the format of the other cells according to the digits of those numbers and get the desired result.

**Read More:** **How to Put 0 in Excel in Front of Numbers (5 Handy Methods)**

### 4. Applying Text Format to Write 00 in Excel

You can also write 00 before numbers by applying the text format. To do so, see the following steps.

**Step 1:**

- Firstly, select the cell range
.*C5:C10* - Then, go to the
group from the*Numbers*tab of the ribbon.*Home* - From the tab, select the small arrow which is at the lower right side of the group.

**Step 2:**

- Secondly, you will see the
dialogue box like in the previous method.*Format Cells* - Then, from the Number tab choose the
tab.*Text* - Lastly, press
.*OK*

**Step 3:**

- Thirdly, type the number
with*5*in the leading position.*00*

**Step 4:**

- Finally, press
and you will see the number will convert into text format and the leading*Enter*won’t disappear.*00*

**Step 5:**

- Consequently, type the other numbers in the following cells in the same way.

**Read More:** **How to Add Leading Zeros in Excel Text Format (10 Ways)**

### 5. Using CONCAT Function to Write 00 in Excel

By using** the CONCAT function** of

**Excel**, you can write 00 before any number. The steps for this procedure are as follows.

**Step 1:**

- First of all, type the following
formula in cell*CONCAT function*.*B5*

`=CONCAT("00",B5)`

**Step 2:**

- Secondly, press
and you will get the desired number with*Enter*in it.*00* - Finally, use
to apply the formula in the lower cells of the data set.*AutoFill*

**Read More:** **How to Add Leading Zeros in Excel by CONCATENATE Operation**

### 6. Utilizing RIGHT Function

** The RIGHT function** in

**Excel**also helps you to write

**before any numbers. We have discussed the detailed steps below for this procedure.**

*00***Step 1:**

- Firstly, type the following formula of
in cell*the RIGHT function*.*C5*

`=RIGHT("00"&B5,3)`

- In the character syntax of the formula, provide the number of digits after adding
to it.*00* - For example, we will use the number
in our first case.*5* - After adding
, it will become a three digits number.*00* - So, in the syntax, we will input
as the number of characters.*3*

**Step 2:**

- Secondly, press
and you will see the number with*Enter*in it.*00*

**Step 3:**

- Thirdly, follow the above steps and modify the formula for the number of digits of the other numbers.
- Finally, you will get the desired results by successfully adding
.*00*

**Similar Readings**

**[Solved]: Leading Zero Not Showing in Excel (9 Possible Solutions)****How to Keep Leading Zeros in Excel CSV (4 Easy Ways)****How to Keep Leading Zero in Excel Date Format (9 Quick Ways)**

### 7. Inserting TEXT Function to Write 00 in Excel

Another method to write ** 00** in

**Excel**is to insert

**the TEXT function**. Let’s go through the following steps for a better understanding.

**Step 1:**

- First of all, type the following formula of
in cell*the TEXT function*.*C5*

`=TEXT(B5,"000")`

- Here, in the format_text syntax, insert the number of digits the required number will become after adding
.*00* - For example, we want to write
as*5*.*005* - So, we will insert three zeroes.

**Step 2:**

- Secondly, press
to get the expected result in cell*Enter*.*C5*

**Step 3:**

- Finally, fill up the other cells in the same way.

### 8. Using TEXTJOIN Function to Write 00 in Excel

Apart from inserting** the TEXT function**, you can also use

**to write**

*the TEXTJOIN function***in**

*00***. How you can do it is given in the following steps.**

*Excel***Step 1:**

- Firstly, in cell
, type the following formula of*C5*.*the TEXTJOIN function*

`=TEXTJOIN("",,"00",B5)`

**Step 2:**

- Secondly, press
to get the desired number with*Enter*in it.*00*

**Step 3:**

- Finally, use the
to apply the formula to the lower cells of that column.*AutoFill*

### 9. Applying BASE Function

Another function that you can apply to write ** 00** in

**Excel**is

**. We are providing more details about this procedure in the following steps.**

*the BASE function***Step 1:**

- First of all, type the following formula of
in cell*the BASE function*.*C5*

`=BASE(B5,10,3)`

- In the min_length syntax of the formula, give the length of the string after transforming.
- For our first example, it is a three-digit number.

**Step 2:**

- Then, press
to see the result.*Enter*

**Step 3:**

- Finally, repeat the above steps with the correct length of string for each input.

### 10. Inserting REPT Function to Write 00 in Excel

The last function we will insert to accomplish our task is** the REPT function**. See the following steps for a better understanding.

**Step 1:**

- In the beginning, type the following
formula in cell*REPT function*.*C5*

`=REPT("00",1)&B5`

- After adding
to the formula, set the number of repetitions of*00*.*00* - As we want to have
only once in our output we will set the number of repeat times to*00*.*1*

**Step 2:**

- Secondly, hit the
button and get the desired result.*Enter* - Finally, drag the
for the final result.*AutoFill*

### 11. Applying VBA to Write 00 in Excel

Finally, for our last method, we will apply a** VBA** code to write ** 00** in

**Excel**. For a better understanding, see the following steps.

**Step 1:**

- Firstly, go to the
tab of the ribbon.*Developer* - Then, from there choose the
command from the*Visual Basic*group.*Code*

**Step 2:**

- Secondly, you will see the
**VBA**window after choosing that command. - Then, from the
tab select*Insert*.*Module*

**Step 3:**

- Thirdly, copy the following
**VBA**code into the module.

```
Sub Write_00_in_Excel()
'Addressing variables
Dim ws As Worksheet
'Giving specific name of the worksheet
Set ws = Worksheets("VBA")
'Writing 00 before a number and we are setting the number format as per the number of digits in that particular number
'Setting the output cell range and the number format
ws.Range("C5").NumberFormat = "000"
'Addressing from cell range from which the number will be changed
ws.Range("C5") = ws.Range("B5")
End Sub
```

**VBA Code Breakdown**

- The function name is
.**Write_00_in_Excel** : We have addressed a worksheet variable.**Dim ws As Worksheet**: Giving the specific name of the current worksheet.**Set ws = Worksheets(“VBA”)**: Setting the output cell location and the number format after adding**ws.Range(“C5”).NumberFormat = “000”**.**00**: Addressing the cell location from which the code will take input.**ws.Range(“C10”) = ws.Range(“B10”)**

**Step 4:**

- Fourthly, save the
**VBA**code and press the play button orto run the code.*F5*

**Step 5:**

- In the fifth step, after playing the code, you will get the following result with
before the number*00*in cell*5*.*C5*

**Step 6:**

- In the sixth step, we will modify the code for the number
in cell*45095*and play it.*C9*

**Step 7:**

- Then, you will get the desired number with
before it after running the code.*00*

**Step 8:**

- Finally, modify the code for each number with its cell location and digit length.
- Consequently, you will see all the numbers with
in the leading position.*00*

**Read More:** **How to Remove Leading Zeros in Excel (7 Easy Ways + VBA)**

## Conclusion

That’s the end of this article. I hope you find this article helpful. After reading the above description, you will be able to write ** 00** in

**Excel**by using any of the above-described methods. Please share any further queries or recommendations with us in the comments section below. The

**Exceldemy**team is always concerned about your preferences.