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

J

Jon C.

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top