In this post I will show you how to convert numbers to text in Excel. I will outline 2 steps needed to do this.
The first step is through a function called text(). Let’s say we have a column of numbers, see below. We want to convert them to text.
We can use a function called text. Go to cell B2 and insert a function and find the TEXT function.
The first part of the function is the reference to the cell we want to convert.
The second part is the formatting of the cell.
Look at the screenshot below. In column B is the actual formula. Column C just shows what is the formula in column B.
So for the first one, we used the formula: =TEXT(A2,”0.00″)
What this does is take the value in A2 which is 33 and converts it to text which looks like 0.00. So that mask says it should have two decimal spots after the number, so our result is 33.00.
You can see how in row 3 and 4 I use different formatting and you get different styles of results.
The second step to convert numbers to text is through Paste Special.
Now that you have the results, they are still a formula. To convert to text completely, you need to hilight column B and click Edit-Copy. Then go to Paste – Special right over the same column B.
It will bring up a wizard with a few options. Click on Values.
Then press ok. Then your results will now be text in column B.