Monday, February 21, 2011

How to Convert a Number to Text in Excel 2007


1. Open the Excel spreadsheet that has the numbers you want to convert to text.
2. Use your mouse to highlight the cell(s) you want to convert to text.
3. Click the 'Home' tab located in the Excel ribbon at the top of the page and look to the 'Number' section of the ribbon.
4. Click the arrow next to 'Number' on the ribbon to open the 'Format Cells' dialog box.
5. Click the 'Number' tab when the 'Format Cells' box opens. A list of options you can convert the numbers to is located in the left pane of the dialog box. Some options you can convert the numbers you selected to include percentages, fractions and text.
6. Select 'Text' from the options and click 'OK.' The numbers you selected on your spreadsheet will now be formatted as text.

Blogger news