That's too bad, Topher. When you are interested in solving your problem,
post back with sufficient information. Like the data you have, the steps you
followed, the results you got, and what you want instead. This problem has
been solved many times before, and I'm sure it can be for you, if you are
interested.

Regards,
Fred

"Topher" wrote in message
...
This does not solve the problem either

"David Biddulph" wrote:

A number of options some of which *might* work:
1 Copy a blank cell, Select your data range, Edit/ Paste special/ Add
2 Select your column of data, then Data/ Text to Columns

Then format the cells appropriately.
--
David Biddulph

"Topher" wrote in message
...
I have a column of dates F6:F148, the dates have been entered in the
following formats all entered as text "21.01.2009","21.1.2009","21 Jan
09"
&
"21 Jan 2009".

I'd like to be able to change them all into a common date format 21 Jan
09
(I'll also change the sheet so that data is validated to this date
format)

Does anyone know a way I can do this?

Thanks


.