G Guest Jun 3, 2004 #1 I am importing data on which includes hundreds of dates in the format 09/11/76. Problem is that I need to sort them by month (ignoring day and year). Is there any way I can do this?
I am importing data on which includes hundreds of dates in the format 09/11/76. Problem is that I need to sort them by month (ignoring day and year). Is there any way I can do this?
D David McRitchie Jun 3, 2004 #2 Hi Emma, create another column and use the fill handle to copy down =Month(A1) Emma said: I am importing data on which includes hundreds of dates in the format 09/11/76. Problem is that I need to sort them by month Click to expand... (ignoring day and year). Is there any way I can do this?
Hi Emma, create another column and use the fill handle to copy down =Month(A1) Emma said: I am importing data on which includes hundreds of dates in the format 09/11/76. Problem is that I need to sort them by month Click to expand... (ignoring day and year). Is there any way I can do this?
