In Excel, it will need to be converted it to a number. To do this

  1. Click the Formulas Tab
  2. Click Error Checking
  3. Error Checking and convert the Values to Numbers 
    User-added image