When a range contains some numbers stored as text

1. On the Tools menu, click Options, and then click the Error Checking tab.
2. Make sure the Enable background error checking and Number stored as text boxes are checked.
3. Select any cell with a green error indicator in the upper left corner .
4. Next to the cell, click the button that appears , and then click Convert to Number.

1. In an empty cell, enter the number 1.
2. Select the cell, and on the Edit menu, click Copy.
3. Select the range of numbers stored as text you want to convert.
4. On the Edit menu, click Paste Special.
5. Under Operation, click Multiply.
6. Click OK.
7. Delete the content of the cell entered in the first step.

Note  Some accounting programs display negative values with the negative sign (–) to the right of the value. To convert the text strings to values, you must return all of the characters of the text string except the rightmost character (the negation sign), and then multiply the result by –1. For example, if the value in cell A2 is "156–" the following formula converts the text to the value –156.