How to Convert Number to Text in Excel (4 Ways)

We use Excel for various purposes, like statistical calculation, analyzing data, making reports, and so on. We can use both text and number formats in Excel. Sometimes, inserting numbers into Excel can cause some problems. In many cases, Excel will not keep zero in the lead position in the number format. Also, Excel will change the last digit to zero if the number is more than 15 digits in the number format. That’s why it is necessary to input the correct format in Excel according to the working purpose. In this article, we will show you how to convert number to text in Excel.


Download Practice Workbook

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


4 Handy Ways to Convert Number to Text in Excel

We will use the following data set in this article. Here, we have a single column containing only numbers in it. In this article, we will describe four different procedures to convert number to text in Excel. We will apply the TEXT function, insert the Text to Columns Wizard feature, add an apostrophe before the number, and alter the cell format for our working purpose.

Handy Ways to Convert Number to Text in Excel

1. Applying TEXT Function to Convert Number to Text in Excel

We can convert number to text by applying the TEXT function of Excel. You can see the following steps regarding the use of this function.

Step 1:

  • First of all, make an extra column in column C to keep the text after converting.

Handy Ways to Convert Number to Text in Excel

Step 2:

  • Then, apply the following TEXT formula in cell C5 for the first number.
=TEXT(B5,"000000")
  • In this formula, in the second argument, we will input six zeroes.
  • So, after converting into text it will become six-digit long.

Handy Ways to Convert Number to Text in Excel

Step 3:

  • Finally, press Enter and the number 450 will turn into text format.
  • Lastly, use the AutoFill feature to drag down the formula for the consecutive numbers.

Handy Ways to Convert Number to Text in Excel

Read More: How to Convert Numbers to Texts/Words in Excel


2. Inserting Text to Columns Wizard to Convert Number to Text in Excel

Another way of converting number to text in Excel is to insert the Text to Columns Wizard feature. Go through the following steps to know more about this feature.

Step 1:

  • Firstly, select all the numbers that you want to convert.

Handy Ways to Convert Number to Text in Excel

Step 2:

  • Then, go to the Data tab of the ribbon.
  • From there, select the Text to Columns command.

Handy Ways to Convert Number to Text in Excel

Step 3:

  • Thirdly, you will see a dialogue box naming Convert Text to Column Wizards – Step 1 of 3 will pop up.
  • In the box, only press Next.

Handy Ways to Convert Number to Text in Excel

  • Again, you will see another dialogue box.
  • In here, press Next also.

Handy Ways to Convert Number to Text in Excel

  • Finally, the third step of the dialogue box will appear.
  • Firstly, select the Text option under the Column data format heading.
  • Then, press Finish after fulfilling the criteria.

Handy Ways to Convert Number to Text in Excel

Step 4:

  • Finally, you will see that all the numbers will turn into text format.
  • Their alignment will be on the left instead of the right, like in the text format in Excel.

Handy Ways to Convert Number to Text in Excel

Read More: Excel VBA to Convert Number to Text (4 Examples)


Similar Readings


3. Adding an Apostrophe to Convert Number to Text

You can also convert a number into text format by adding an apostrophe before the number. You will get a clear idea about this after seeing the following steps.

Step 1:

  • First of all, create an extra column for the output in text format.

Handy Ways to Convert Number to Text in Excel

Step 2:

  • Then, type the number in the formula bar and add an apostrophe before the value (‘450).

Handy Ways to Convert Number to Text in Excel

  • Now, this will change the format of the number to text in your worksheet.

Handy Ways to Convert Number to Text in Excel

Step 3:

  • Now, use the same procedure for the other numbers as well.

Sample Data Set

  • Finally, you will see all the numbers in text format after converting.

Sample Data Set

Read More: How to Convert Number to Text in Excel with Apostrophe


4. Altering Cell Format to Convert Number to Text

In our last method, we will alter the format of the number cells to convert them into text. For that, do the followings.

Step 1:

  • Firstly, select all the numbers in the data set.

Sample Data Set

Step 2:

  • Then, from the Home tab of the ribbon, go to the Numbers group.

Sample Data Set

  • After that, from the Number Format drop-down, choose Text as the format of the selected cells.

Sample Data Set

Step 3:

  • Finally, you will find all the numbers in the cell will convert into text format as they will align from the left side.

Sample Data Set

Read More: Excel VBA: Convert Number to Text with Format (A Total Guide)


Conclusion

That’s the end of this article. I hope you find this article helpful. After reading this article, you will be able to convert number to text in Excel by using any of these methods. Please share any further queries or recommendations with us in the comments section below.


Related Articles

Araf

Araf

I am Araf. I have completed my B.Sc in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Currently I am working as an Excel & VBA Content Developer in Softeko. With proper guideline and aid of Softeko I want to be a flexible data analyst. With my acquired knowledge and hard work, I want to contribute to the overall growth of this organization.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo