Mongoose
Has absolutely no life
- Joined
- Jun 5, 2011
- Messages
- 389
- Reaction score
- 695
This is a bit of a dummy question, but...
I have a spreadsheet where I have a list of catalog numbers in the format of 1-5, 1-6, 10-1, 115-2, and so forth. The first number is the Field Sort number, and the second is the actual item's number (so 1-5 would be the 5th item from FS#1). I need to sort it numerically because that's the order in which it was excavated, and I need this because it'll show me roughly what was in the ground above other things.
This is before sorting.
This is AFTER sorting.
There's too many pieces right now for separating the values in separate columns to be practical.
Anyways, so I'm trying to sort the values, and it keeps sorting only by the first digit or so, so catalog numbers 1-1, 100-1 and up keep getting sorted before 2-1 and such. How do I fix this?
I have a spreadsheet where I have a list of catalog numbers in the format of 1-5, 1-6, 10-1, 115-2, and so forth. The first number is the Field Sort number, and the second is the actual item's number (so 1-5 would be the 5th item from FS#1). I need to sort it numerically because that's the order in which it was excavated, and I need this because it'll show me roughly what was in the ground above other things.
This is before sorting.
There's too many pieces right now for separating the values in separate columns to be practical.
Anyways, so I'm trying to sort the values, and it keeps sorting only by the first digit or so, so catalog numbers 1-1, 100-1 and up keep getting sorted before 2-1 and such. How do I fix this?
