Sometimes we need to add new digits to the existing number. We can add new digits to a number in different ways. We may add new digits at the front or the last of the existing number in Excel. In this article, we will learn how to add **2** digits to a number in Excel.

**Table of Contents**hide

**Download Practice Workbook**

Download this practice workbook to exercise while you are reading this article.

**4 Methods to Add 2 Digits to a Number in Excel**

We have taken a dataset of some sample numbers. We will show how to add **2** new digits to those existing numbers in the below section.

**1. Add 2 Digits to a Number Using Ampersand (&) Operator**

In this section, we will use **Ampersand (&)** symbol and **Quotation Mark (” “)** to add **2** digits.

**📌 ****Steps:**

- Add a new column in the dataset.

- Go to
**Cell C5**. - Now, put the following formula.

`="11"&B5`

We put **2** digits inside the quotation mark. If we want to add more numbers of digits, just put them inside the quotation mark.

- Press the
**Enter**button.

We get the result after adding new digits.

- Now, drag the
**Fill Handle**icon.

We can also add digits at the end of the existing number. For this use the formula below.

`=B5&"11"`

Here, we put the ampersand symbol and the new digit after the existing number.

**Read More: How to Add Digits to a Number in Excel (8 Easy Methods)**

**2. Use Format Cells Option**

In this section, we will use the **Format Cells** option to add **2** digits to the existing number in Excel.

**📌 ****Steps:**

- First, copy and paste the existing numbers into the newly added column.

- After that, select the dataset.
- Then, press the right button of the mouse.
- Choose the
**Format Cells**option from the**Context Menu**.

- The
**Format Cells**window appears here. - Choose the
**Custom**option from the**Number**tab. - Insert a format in the
**Type**box.

- Finally, press
**OK**.

We can see that **2** digits are added here.

- We can also add new digits at the end of the numbers.

- We can also add new digits on both sides at the same time.

**Read More: How to Add 1 to Each Cell in a Column in Excel (5 Easy Methods)**

**3. ****Add 2 New Digits by Summing**

In this section, we can only add new digits at the starting of the existing number. We will sum a new number with the existing number, which will add **2** new digits.

**📌 ****Steps:**

- Go to
**Cell C5**. - We want to add
**12**at the front of the existing number. - So, put the following formula.

`=B5+1200000`

One thing that needs to keep in mind is that after the new **2** digits we will put several zeros that are equal to the number of digits of the existing number.

- Now, press the
**Enter**button.

- Then, pull the
**Fill Handle**icon.

We can see new **2** digits are added to the existing number. We can not add new digits at the end of the number.

**Read More: How to Add a Number in Front of a Number in Excel (7 Easy Ways)**

### 4. Use Excel Functions to Add 2 Digits to a Number

#### 4.1 Using CONCATENATE Function

The **CONCATENATE **function joins several text strings into one text string.

In this section, we will use the **CONCATENATE** function. This function joins several texts.

**📌 ****Steps:**

- Put the following formula on
**Cell C5**.

`=CONCATENATE("25",B5)`

- Hit the
**Enter**button and drag the**Fill Handle**button.

We can see new digits are added. We can also add digits at the last.

#### 4.2 Using NUMBERVALUE Function

The **NUMBERVALUE function** converts text to numbers in a local-independent manner

In this section, we will use the **NUMBERVALUE **function. We will use an ampersand symbol between the new digits and the existing number.

**📌 ****Steps:**

- Just put the formula based on the
**NUMBERVALUE**function on**Cell C5**.

`=NUMBERVALUE(12&B5)`

- Now, hit the
**Enter**button and drag the**Fill Handle**icon.

New digits have been added successfully.

#### 4.3 Using IF Function

The **IF function** checks whether a condition is met, and returns one value if **True**, and another value if **False**.

We can use the **IF **function to add new digits here.

**📌 ****Steps:**

- Put the below formula on
**Cell C5**.

`=IF(B5<>"","44"&B5,"")`

- Hit the
**Enter**button now. - Drag the
**Fill Handle**icon downwards.

New digits are added here.

**Read More: How to Add Number to Existing Cell Value in Excel**

**Conclusion**

This article described how to add **2** new digits to the existing number in Excel. I hope this will satisfy your needs. Please look at our website **Exceldemy.com** and give your suggestions in the comment box.