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