When importing data from the Web into Excel the data sometimes
does not get stored as numeric data. To solve this problem and have
the text converted to a number use the following steps:

Right Click the problematic Cell
Data Range Properties
Uncheck Save Query Definition - OK
Ok

Problematic cells should have a small green triangle in the
upper left corner.

Formulas Tab from the Web does not get stored as numeric data.
Right Click Cell
Data Range Prope
Error Checking

This should provide a popup box that runs through each cell with a problem.
Choose Convert To Number to fix the cell.