====== 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.

===== External Links =====
  * https://support.microsoft.com/en-us/kb/291047