Try the following to convert text to number. Enter 1 in some
empty cell and copy it. Then select your range of data. Go to the
Edit menu, choose Paste Special and select the Multiply
operation. Click OK.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Daminc"
wrote in message
...

I copy and paste numerical order numbers from the web onto a
spreadsheet
and sort them.

I usually use a Macro to do this but recently the numbers don't
sort
properly anymore.

It seems like some of these numbers are actually text but even
after I
format the cells to 'Number' they still do not sort.

I believe I've copied over some format or other with the number
but
even copy / paste special values doesn't seem to help.

Can anyone tell me what the score is here.

Below is an example of the numbers I'm trying to sort:


90721
90728
90731
90826
90851
90872
1002894
90709
90738
90851
90878
90903


--
Daminc
------------------------------------------------------------------------
Daminc's Profile:
http://www.excelforum.com/member.php...o&userid=27074
View this thread:
http://www.excelforum.com/showthread...hreadid=530501