View Single Post
  #2   Report Post  
bj
 
Posts: n/a
Default

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)

"Betty" wrote:

How to sort by year with this format Sept 9/03