| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
sort numbers based on initial digit.
running excell 2002.
I have a list of part numbers starting 1xxxxxxxxx (8 digits total) and ending 9(4 digits). Default will put the larger number of digits last but I need the first number of the sequence to be the primary sort number. eg: 12345678, 2345, 6, 789, 8, 99999. etc. Any simple solution? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) | |||
| Return a digit in a string of numbers | Excel Discussion (Misc queries) | |||
| Numbers won't sort correctly. | Excel Discussion (Misc queries) | |||
| Numbers won't sort correctly. | Excel Discussion (Misc queries) | |||
| Tell users how to sort 5 digit and 9 digit zipcodes correctly aft. | New Users to Excel | |||
Threaded Mode
