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