View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dan Harlan Dan Harlan is offline
external usenet poster
 
Posts: 1
Default How to convert date from "Fri Aug 22 13:49:20 EDT 2003"

Need to convert a bunch of text files that include dates in the "Fri Aug 22
13:49:20 EDT 2003" format. Have been unable to break them into separate
columns during import as the other columns are all tab delimited. Wish to
convert this into a standard date/time format. How best to achieve this as I
have numerous files to do this with. TIA, ~Dan