replace "." with "/"

O

omneo

hi

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

thanks
omne
 
B

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

--
 
Top