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.
Read More: How to Add a Number in Front of a Number in Excel
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
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
Conclusion
This article described how to add two new digits to the existing number in Excel. I hope this will satisfy your needs. Please give your suggestions in the comment box.
Related Articles