Convert Text to Number
- In any blank cell, type the value 1.
- Make sure the cell you typed 1 in is formatted as a number.
- Select the cell in which you typed 1, and then right click and choose Copy.
- Select the cells with the values that you want to convert to numbers.
- Right click and choose Paste Special.
- Under Operation, click Multiply and then click OK.