How to sort by year with this format Sept 9/03
B bj Jun 2, 2005 #2 Is the data formated to look like that or is it a text entry? if it is a format. It will sort just using any sorting procedure. if it is text use a helper column with =right(A1,2)
Is the data formated to look like that or is it a text entry? if it is a format. It will sort just using any sorting procedure. if it is text use a helper column with =right(A1,2)