Excel Buff Needed

Date Formatting - 12/12/2004 not 12.12.2004

[limbo]

I have been given a very long list of info.

Column 1 Has the d/m/y separated by a backslash eg: 12/12/2005
Column 2 Has the d/m/y part separated by a period eg: 12.12.2005

I need to format column 2 so that excel sees its contents as dates not 'general'. However when I select the cell or column and right click > format cells > date it does nothing. Anyone know how to convert them to dates so I can apply formulas across the two. Or maybe a clever F&R / Toolkit function?

Ta

[limbo]

Doh!

Select column 2 >

Find: .
Replace with: /

:)

Should have gone to bed earlier last night!