Select that column
Data|Text to columns
fixed width (but remove any lines that excel guessed)
Tell excel that the field is a date in dmy order

And finish up.

CM wrote:

Hi

Using Excel 2003.

I have a long list of dates in the format 14.6.61. These are currently
aligned to the left and are considered to be text. Changing the format
to date doesn't appear to make any changes. The column begins at D1
with the word 'DOB'.

How can change these data to date format?

Thanks

--

Dave Peterson