Hi All, Great to know you are there.
I'm sorting data by two columns, first Estate and then by House No. However I find that the house numbers don't sort correctly. i.e in the various sorted Estate groupings there's an occasional house number out of order or mis-sorted. e.g. it would be sorted 1, 2, 3, 5, 8, 15, 17, 24, 35, 6. Six being the problem.
I've checked for extra spaces before or after and that looks OK. Any suggestions.
The information I'm sorting is initially filtered on the Estate column to hide blank cells and I'm using Excel 2003
I'm not sure if I should start a new thread for this but house no's with letters e.g 125a sorts to the bottom of the numbers.

Thank you for any help offered.