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

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

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"stuckiniraq" wrote in message
...
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