View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sageman Sageman is offline
external usenet poster
 
Posts: 3
Default Change format of a date field

I have been given a csv file - on opening in excel the dates are in the
format 25051917, 5051949, 23121979 etc.
I have been struggling to get them into the standard date format - in this
case 25/05/1917, 05/05/1949, 23/12/1979 etc. Any help appreciated.