How to change a non standard date list into correct date format?

Hi,

I have a list of dates written in the formation 17.04.10 etc

I need to be able to use these dates to run calculations but this isnt a recognised format.

How can I automatically change this list into 17/4/10 format?

Thanks

In terms of conversion, either:

a) run Edit Replace on the values replacing . with -

b) use Text to Columns -> Step 3 choose Date -> DMY and click Finish

I'd try a global replace of "." for "/" first. That worked for me.

Other than that, try the formula:

=DATE(RIGHT(A2,2)+2000,MID(A2,4,2),LEFT(A2,2))

with the date in A2

Regards