Excel: Text to Number

Use the Text to Columns Command

This method works best if the data is arranged in a single column. The following example assumes that the data is in column A and starts in row 1 ($A$1). To use this example, follow these steps:

1. Select one column of cells that contain the text.
2. On the Data menu, click Text to Columns.
3. Under Original data type, click Delimited, and click Next.
4. Under Delimiters, click to select the Tab check box, and click Next.
5. Under Column data format, click General.
6. Click Advanced and make any appropriate settings for the Decimal separator and Thousands separator. Click OK.
7. Click Finish.