V VH5150 Board Regular Joined Mar 1, 2004 Messages 60 Nov 18, 2005 #1 I have a column of cells with a date formatting like Jun-04. I would like to place a column beside it that has the serial date so I can sort the column in chronological order. Any ideas? Thanks, Eddie
I have a column of cells with a date formatting like Jun-04. I would like to place a column beside it that has the serial date so I can sort the column in chronological order. Any ideas? Thanks, Eddie
Norie Well-known Member Joined Apr 28, 2004 Messages 76,059 Office Version 365 Platform Windows Nov 18, 2005 #2 Eddie Are these actually dates, just formatted for month/year? If they are then you shouldn't need to change them to sort them.
Eddie Are these actually dates, just formatted for month/year? If they are then you shouldn't need to change them to sort them.
V VH5150 Board Regular Joined Mar 1, 2004 Messages 60 Nov 18, 2005 #3 Good Point This works! Maybe I'm retarded. Sorry to waste your time.