Thread: Date Formatting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Robin Gray Robin Gray is offline
external usenet poster
  
Posts: 2
Default Date Formatting
I have a csv file which when opened with excel shows dates as 15041978 or
4051949. I am struggling to convert these to the normal format 15/04/1978
or 04/05/1949.
Any suggestions.

TIA


Reply With QuoteReply With Quote