# How to Add 2 Digits to a Number in Excel (4 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

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.

## How to Add 2 Digits to a Number in Excel: 4 Quick Methods

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.

### 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. ### 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.

### 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. ## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems. Alok Paul

Hello, this is Alok. I am working as an Excel & VBA Content Developer at Exceldemy. I want to provide solutions to various Excel-based problems. I completed my study at East West University major in Telecommunications Engineering. I love traveling, reading books, playing cricket.

We will be happy to hear your thoughts Advanced Excel Exercises with Solutions PDF  