Excel not recognizing numbers in cells?

Follow up comment to my last message...

I note you say you copied your numbers from a web page; that means it is possible that your spaces are not ASCII 32 spaces, but rather are ASCII 160 non-breaking spaces. If my previous suggestions doesn't work for all your numbers, go back to the Replace dialog bog and remove the space character that is in the "Find what" field and enter this keystroke combination into that field in its place... ALT+0160 but you MUST type those four digits from the NUMBER PAD, not the main keyboard.... then click the "Replace All" button.

Check out whether there are spaces before or ater the cellss..If so try replacing the spaces.

Another way to easily convert these cells to numeric format if you have enabled error checking for these cells. Check whether the cells are in text format. (Right click>FormatCells). To convert the cells to numerics do the below.

In 2003 Tools>Options>Error checking>'Number stored as text'

In 2007 OfficeButton>ExcelOptions>Formulas>Error checking>

--If you have this option checked; then error checking is enabled for such cells.

--For cells with numeric value but formatted as text; on the left top corner of the cell you will see a green triangle.

--Select the range of cells and make sure one of the cells with the green triangle is the active cell (cell with white background).

--Click/dropdown on the error information popup which is displayed towards the left of the active cell

--Select 'Convert to number'

Yet another work around is

--Copy a blank cell

--Keeping the copy select the range of cells with numeric values

--Right click>PasteSpecial>

--Select 'Add' and click OK.