H
houstonguy78
Hello, I am having a problem sorting two columns (one is the street
name and the other is the street number eg. 321 Smith St) in Excel
2007 by using a custom sort. Let's say that the data in column A is
the number and B is the street name. I have the sort setup to sort
first by B then by A. The problem is with the numbers. Some numbers
are out of order in the spreadsheet although the majority are
correct. I have formatted the number column (A) as a number as well.
I have also tried creating a new spreadsheet and pasting (paste
special) the data into it with the same result. Can anyone help me
out on this one?
name and the other is the street number eg. 321 Smith St) in Excel
2007 by using a custom sort. Let's say that the data in column A is
the number and B is the street name. I have the sort setup to sort
first by B then by A. The problem is with the numbers. Some numbers
are out of order in the spreadsheet although the majority are
correct. I have formatted the number column (A) as a number as well.
I have also tried creating a new spreadsheet and pasting (paste
special) the data into it with the same result. Can anyone help me
out on this one?