I am trying to sort a column within a table that contains a five or six digit serial number. First two digits are the year (77 through 11, for 1977 through 2011) and last three or four digits are the actual serial number. Unfortunately, since the dates don't include the 19 or 20 prefix the serial numbers don't sort in true "chronological" order, just as hard numbers. I can't add the 19 or 20 prefixes to the serial number (unless they won't be visible to the user when displayed). File resides on unix mainframe on network and therefore any macros or VBA may be problematic. Please see attached file for numbers in question.
Thanks for any help!
Bookmarks