sorting column of numbers

J

joeydusmc

trying to sort a column of numbers. Ive made sure they are all numeric not
text but it still wont sort. Some of it sorts but it seems to restart midway
down the column and starts sorting again from lowest to highest. It's a
column of 5 didgit zip codes. Also I mearged (cut and paste) a couple
worksheets together. Not sure if this is causing the problem. I'm a real
novice so be gentle!
 
S

Sheeloo

Just to make sure...
Insert a Col
Copy the numbers from original col and do EDIT|PASTE SPECIAL|VALUE on the
news col... Then sort on the new Col

If you find that all are not numbers then enter 1 anywhere, copy it, Select
your original columns and do EDIT|PASTE SPECIAL|MULTIPLY
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel finding top of range 1
Auto Sorting Data in Table 1
Sorting in multiple worksheets 1
Sorting Columns by number of characters 1
How can I sort a column of numbers generated by excel RAND funct? 5
Sorting by rows with differing numbers of cell entries 3
Sorting formatted numbers 2
sorting hyphenated numbers 3

Top