Forum Home
Press F1
 
Thread ID: 4280 2000-05-16 07:11:00 Numerical sorting in Excel 97 Guest (0) Press F1
Post ID Timestamp Content User
4751 2000-05-16 07:11:00 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? Guest (0)
1