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

S

stuckiniraq

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
 
M

Max

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
 
Top