Imported data not being treated as numbers

Hi

I have scraped a bunch of data from a website using a webcrawler. The webcrawler then exports the data as an Excel file. However, the data that is returned is not being treated as numbers, therefore I cannot add/subtract etc.

Attached is a sample.

I've tried formatting number and I've tried copy and pasting as values, but no luck.

How can I tell Excel that these are numbers?

Thanks

Double click on any of those cells. You will see that there is an "Alt Enter" character, CHAR(10), after the numbers.

To get rid of that, you can put this in G1:
=CLEAN(A1)+0
and drag it to the right and down.

You can then copy/paste these as values.

Another option
Select all the data > Ctrl H > in the find what box type Ctrl J > leave replace with empty > Replace All

Originally Posted by Fluff13

Another option
Select all the data > Ctrl H > in the find what box type Ctrl J > leave replace with empty > Replace All

I was actually trying to do it this way, as it is the best option in my opinion.

What is Ctrl J? Does that put in the CHAR(10) character?

Originally Posted by 63falcondude

What is Ctrl J? Does that put in the CHAR(10) character?

Yes it does. You should see the cursor disappear to be replaced by a blinking dot in the bottom left hand corner of the box (this is actually the top of the cursor after it has moved to the next line).
You can alternatively use Alt 010 (but you need to use the number keypad)