Excel - convert multiple text cells to values

To use the Paste Special command, follow these steps:

1. In any blank cell, type the value 1.
2. Select the cell in which you typed 1, and then click Copy on the Edit menu.
3. Select the cells with the values that you want to convert to numbers.
4. On the Edit menu, click Paste Special.
5. Under Operation, click Multiply. Under Paste, click Values, and then click OK.