Thread: automatic date formatting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Terry Freedman Terry Freedman is offline
external usenet poster
  
Posts: 10
Default automatic date formatting
Hi
When I import data from a survey into excel, it automatically converts
a column containing age ranges to dates. EG, it converts 5-7 to 5th
July. Is there any way to prevent this happening please?

Thanks
Terry

Reply With QuoteReply With Quote