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

Get FREE Advanced Excel Exercises with Solutions!

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.

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

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

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.

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.

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

Step 2:

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

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.

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

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

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.

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

Step 2:

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

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

Step 3:

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

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

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

Step 2:

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

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

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.

## Related Articles

Md. Araf Bin Jayed

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

Advanced Excel Exercises with Solutions PDF