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

Similar Threads

VBA - exporting serial letters to single documents 0
Forcing a date entry format of dd/mm/yyyy 1
How to enter a date in DD-MM-YYYY format 2
Change format to mm dd yyyy hh mm ss 1
format cells from mm/dd/yyyy to yyyy 3
Publisher is filling blank lines with data 2
Converting date format 4
reformat dates to yyyy/mm/dd 5

Top