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.

Step

Open a new workbook in Microsoft Excel.

Step

Type the list of numbers you would like to convert to text down a column.

Step

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.

Step

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.