Thread: Date Formatting
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Robin Gray Robin Gray is offline
external usenet poster
  
Posts: 2
Default Date Formatting
Thanks Guys

"Robin Gray" wrote in message
et...
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