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.
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.
- First of all, make an extra column in column C to keep the text after converting.
- Then, apply the following TEXT formula in cell C5 for the first number.
- In this formula, in the second argument, we will input six zeroes.
- So, after converting into text it will become six-digit long.
- 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.
- Firstly, select all the numbers that you want to convert.
- Then, go to the Data tab of the ribbon.
- From there, select the Text to Columns command.
- 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.
- 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.
- How to Convert Number to Text with Green Triangle in Excel
- Convert Number to Words in Excel in Rupees
- How to Convert Text to Numbers in Excel
- Convert a Numeric Value into English Words in Excel
- How to Convert Peso Number to Words in Excel (With Easy Steps)
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.
- First of all, create an extra column for the output in text format.
- 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.
- 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.
- Firstly, select all the numbers in the data set.
- 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.
- Finally, you will find all the numbers in the cell will convert into text format as they will align from the left side.
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.
- How to Convert Date to Text Month in Excel (8 Quick Ways)
- Convert Date to Text YYYYMMDD (3 Quick Ways)
- How to Convert Number to Text for VLOOKUP in Excel (2 Ways)
- Convert Number to Text and Keep Trailing Zeros in Excel (4 Ways)
- How to Convert Number to Text without Scientific Notation in Excel
- Convert Number to Text with 2 Decimal Places in Excel (5 Ways)
- How to Convert Number to Text with Leading Zeros in Excel