Use TTC (Text to Columns).

Select the column, then:
<Data <Text To Columns
And click "Delimited", then <Next <Next

Click on "Date", and make sure that "DMY" shows in the window,
Then <Finish,
And you've got XL recognized dates.

You can now format the data any way you wish.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ben" wrote in message
...
Want to convert text date "30 AUG 2006" to a date. Have used
"=DATEVALUE()"
but comes back with #value!.
Would greatly appreciate help here.