When I copy and paste text from a web page in to excel, the numbers in the cells are not recognized as numbers and therefore no calculation is possible (#VALUE error) by using this numbers.
I have tried solutions like changing cell format, Paste Special multiply or add 0, Value() Function, Text...