Tuesday, August 28, 2012

How to Convert Numbers to Text in Microsoft Excel


1. Open a new workbook in Microsoft Excel.
2. Type the list of numbers you would like to convert to text down a column.
3. 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.
4. 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.

Blogger news