Very wierd error unable to add numbers

I had copied some values from a website, and wanted the sum of them. there are two columns in particular that i require the sum of. One is the time taken and two are the numbers corresponding to the same. WHile I am able to add the time, I am unable to add the numbers. Its very wierd. I cant perform any operations on the numbers, tried googling and changing formatting etc.

Please help (im not particularly new to excel, yet I have never seen anything like this -_-)

Im sure you can do what olly says but
=SUBSTITUTE(D1,CHAR(160),"")*1
will turn the current entries into numbers that can be summed

Hi,

You have a hidden space behind the number. First select all and change to Number format.

Then select all the number cells, then tick replace under the "find & select" button in the ribbon. Under find what, you just hit the "space" on your keyboard once. Now you just see 0.00 (your numbers are very small). So use the adding decimals button until you have the number of decimals you want.

Now you can calculate what ever you want with these numbers.

Ian