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?

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Jon C." <Jon C.@discussions.microsoft.com> wrote in message
news:266B7011-244F-46D2-8C8A-(E-Mail Removed)...
>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?