View Full Version : Numerical sorting in Excel 97

16-05-2000, 07:11 PM
I often have to sort lists of addresses, but find that street numbers sort simply by the first digit, then the second etc, so I get 1, 10, 11...2, 20,21 etc. Is there a way around this without adding leading zeroes?