Dates saved as 13.2.2014

[themob212]

Hey guys, I am just working on a spreadsheet which is full of dates formated as 1.1.2000 for example as text. I need them as date values formated as 1/1/2000. Any quick and simple way of doing it (I suspect I could do it with VBA but was checking before I put the effort in).

Any help would be wonderful.

Thank you!

[Sam Capricci]

consider find . and replace all with / ?

[Punnam]

=SUBSTITUTE(A1,".","/")
Paste in b1
Considering that you have data in A1 and drag it down

Punnam