How to Convert Numbers to Text in Microsoft Excel
Oftentimes, you may want to express numbers as text in currency or other units in Microsoft Excel. Follow the simple steps below to learn how.
Things You'll Need
- Microsoft Excel
Open a new workbook in Microsoft Excel.
Type the list of numbers you would like to convert to text down a column.
Type =Text(cell,"units") in the next empty column or row, where "cell" is the cell containing the number you want to convert and "units" is the unit you want the number to be expressed in. For example, if you have 10 in cell A1 and want to express it in U.S. dollars, type =text(A1,"$0.00") in cell B1.
Click on the cell containing the formula and go the lower right-hand corner of the cell until your mouse pointer turns into + sign. Drag the formula down the column to the last row containing data.
Tips & Warnings
- If you want to add a text string such as "per hour," go to the next empty column and type =concatenate(cell containing text,"per hour"), where "cell containing text" refers to the cell that contains the converted text value. In the above example, it would appear as $10 per hour. Drag the formula down the column to extend it to the rest of the data.