replace "." with "/"

[omneo]

hi

ive got a LONG list of details with the date entered as 12.12.2005 instead of 12/12/2005. is there a way to change the . for a /

thanks
omneo

[Bryan Hessey]

Hi,

If this is in an Excel column, select the column, Edit, Replace, put . in the Find What, and / to replace with, and Replace All.

Hope this helps

--

hi

ive got a LONG list of details with the date entered as 12.12.2005 instead of 12/12/2005. is there a way to change the . for a /

thanks
omneo

[omneo]

exactly what i was looking for

thanks