Thread: How do i change format of cell from 02.02.08 to 02/02/08?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
MartinW MartinW is offline
external usenet poster
  
Posts: 860
Default How do i change format of cell from 02.02.08 to 02/02/08?
Hi Kishalin,

Assuming your data is text
Select your data
Go to EditReplace
Find what: .
Relace with: /
Click Replace All

HTH
Martin



"Kishalin" <Kishalin @discussions.microsoft.com wrote in message
...
How would i change the format of a cell with out retyping the information.
e.g 02.02.08 to 02/02/08


Reply With QuoteReply With Quote