View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default 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