How to convert numbers to text using Excel TEXT function and other options

Convert number to text using the Excel TEXT function

The most powerful and flexible way to convert numbers to text is using the TEXT function. It turns a numeric value into text and allows to specify the way this value will be displayed. It's helpful when you need to show numbers in a more readable format, or if you want to join digits with text or symbols. The TEXT function converts a numeric value to formatted text, thus the result cannot be calculated.

If you are familiar with using formulas in Excel, it will not be a problem for you to employ the TEXT function.

1. Add a helper column next to the column with the numbers to format. In my example, it's column D.
2. Enter the formula =TEXT(C2,"0") to the cell D2. In the formula, C2 is the address of the first cell with the numbers to convert.
3. Copy the formula across the column using the fill handle.
   
4. You will see the alignment change to left in the helper column after applying the formula.
   
5. Now you need to convert formulas to values in the helper column. Start with selecting the column.
6. Use Ctrl + C to copy. Then press the Ctrl + Alt + V shortcut to display the Paste Special dialog box.
7. On the Paste Special dialog, select the Values radio button in the Paste group.
   

   You will see a tiny triangle appear in the top-left corner of each cell in your helper column, which means the entries are now text versions of the numbers in your main column.
   

   Now you can either rename the helper column and delete the original one, or copy the results to your main and remove the temporary column.

   Note. The second parameter in the Excel TEXT function shows how the number will be formatted before being converted. You may need to adjust this based on your numbers:

   The result of =TEXT(123.25,"0") will be 123.

   The result of =TEXT(123.25,"0.0") will be 123.3.

   The result of =TEXT(123.25,"0.00") will be 123.25.

   To keep the decimals only, use =TEXT(A2,"General").

   Tip. Say you need to format a cash amount, but the format isn't available. For instance, you cannot display a number as British Pounds (£) as you use the built-in formatting in the English U.S. version of Excel. The TEXT function will help you convert this number to Pounds if you enter it like this: =TEXT(A12,"£#,###,###.##"). Just type the format to use in quotes -> insert the £ symbol by holding down Alt and pressing 0163 on the numeric keypad -> type #,###.## after the £ symbol to get commas to separate groups, and to use a period for the decimal point. The result is text!

Use the Format Cells option to convert number to text in Excel

If you need to quickly change the number to string, do it with the Format Cells… option.

1. Select the range with the numeric values you want to format as text.
2. Right click on them and pick the Format Cells… option from the menu list.
   

   Tip. You can display the Format Cells… window by pressing the Ctrl + 1 shortcut.

3. On the Format Cells window select Text under the Number tab and click OK.
   

You'll see the alignment change to left, so the format will change to text. This option is good if you don't need to adjust the way your numbers will be formatted.

Add an apostrophe to change number to text format

If these are just 2 or 3 cells in Excel where you want to convert numbers to string, benefit from adding an apostrophe before the number. This will instantly change the number format to text.

Just double-click in a cell and enter the apostrophe before the numeric value.

You will see a small triangle added in the corner of this cell. This is not the best way to convert numbers to text in bulk, but it's the fastest one if you need to change just 2 or 3 cells.

Convert numbers to text in Excel with Text to Columns wizard

You may be surprised but the Excel Text to Columns option is quite good at converting numbers to text. Just follow the steps below to see how it works.

1. Select the column where you want to convert numbers to string in Excel.
2. Navigate to the Data tab in and click on the Text to Columns icon.
   
3. Just click through steps 1 and 2. On the third step of the wizard, make sure you select the Text radio button.
   
4. Press Finish to see your numbers immediately turn into text.