Converting MM/DD/YYYY into just MM/DD and Sorting
 

I have several thousand dates that I imported into and excel sheet and need
to sort it by MM/DD only. The years are all different. I tried to format
the cells in the column by MM/DD and then sort, but it is still sorting by
MM/DD/YYYY. How do format the cells to drop the YYYY and only leave the
MM/DD without going into each cell and deleting the YYYY from each cell?

Converting MM/DD/YYYY into just MM/DD and Sorting
 

Insert a column. Formula: =TEXT(A1,"mmdd")
Sort on that column

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Jon C." <Jon wrote in message
...
I have several thousand dates that I imported into and excel sheet and need
to sort it by MM/DD only. The years are all different. I tried to format
the cells in the column by MM/DD and then sort, but it is still sorting by
MM/DD/YYYY. How do format the cells to drop the YYYY and only leave the
MM/DD without going into each cell and deleting the YYYY from each cell?