View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Paul Paul is offline
external usenet poster
 
Posts: 16
Default How do i change format of cell from 02.02.08 to 02/02/08?

On 4 Apr, 11:08, Kishalin <Kishalin @discussions.microsoft.com wrote:
How would i change the format of a cell with out retyping the information.
e.g 02.02.08 to 02/02/08


A quick way is ti highlight all cells anf Find & Replace