How do I sort dates stored as 1-Jun-05 in order of day & month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column that has dates entered as 1-Jun-5 so numbers and text and I
cant seem to get it to sort by month and day. When I try to change all the
dates to numbers only it wont change them all. HELP
 
Try this ..

Select the col with the dates

Click Data > Text to Columns
Click Next > Next

In step 3 of the wizard:
Under Column data format,
Check "Date" (ensure "DMY" is selected in the droplist)
Click Finish
 
You must log in or register to reply here.

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

Sorting day names chronologically 5
Lookup date between 2 dates 1
2 criterias in lookup 1
Excel Message box with days of month & date. 1
Customise a Date to display as something else 2
how do i create a formula in Excel - count by a specific date 4
Summing weekly values to fall into correct month 2
Calculating total number of days 3

Back
Top