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

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.


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

Add Digits Using Ampersand (&) Operator in Excel

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.

Add Digits Using Ampersand (&) Operator in Excel

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.

Use of Format Cells Option to add 2 digits

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

Use of Format Cells Option to add 2 digits

  • Finally, press OK.

We can see that 2 digits are added here.

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

Use of Format Cells Option to add 2 digits

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

Use of Format Cells Option to add 2 digits


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

Add 2 New Digits by Summing

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)

Use Excel Functions to Add 2 Digits to a Number

  • 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)

Use Excel Functions to Add 2 Digits to a Number

  • 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,"")

Use Excel Functions to Add 2 Digits to a Number

  • Hit the Enter button now.
  • Drag the Fill Handle icon downwards.

New digits are added here.


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.

Alok

Alok

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

Leave a reply

ExcelDemy
Logo