replace "." with "/"
 

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

replace "." with "/"
 

Select that column
edit|replace
what: . (dot)
with: / (slash)
replace all



omneo wrote:

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

--

Dave Peterson

replace "." with "/"
 

Highlight the entire area and press Ctrl+H and under find what put . and
replace by /


--
William Okumu
------------------------------------------------------------------------
William Okumu's Profile: http://www.excelforum.com/member.php...o&userid=33745
View this thread: http://www.excelforum.com/showthread...hreadid=535643