Change cell format to make Sum function possible

Hello everybody,

Here a relatively simple question I guess.
Here is my problem: in the attached file you see a table, from this table I want to determine the
sum from D1:D10. I copied the data from a website and think that the format isn't compatible with excel,
anyway I tried a lot of things (the substitute function to delete the spaces and the replace function of excel
to delete the Euro signs). All this failed, hopefully someone has an answer to this at first sight easy question.

Thnx!Sum of numbers.xlsx

The spaces typically used on the internet are different (ASCII wise) than the traditional spaces. The spaces in your cells are code 160 whereas typical spaces are 32.

Select your range Col D, CNTRL H to bring up search/replace
Place curser in FIND box
On a laptop, FN + ALT (using keypad numbers 0160)
Replace All
Did that work for you?

It did on the worksheet you sent me.

Did it say that it replaced anything? I know in some laptops, you need to use FN ALT 00160. An easier way might be to copy one of those blank spaces from the formula bar and paste it into the SEARCH/REPLACE window