View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default Importing .txt data into Excel

I am trying to import a .txt file with a 6 digit date into Excel. The date
is formatted as a mmddyy and when changing this field to a date excel seems
to translate any yy = 30 as 1930 instead of 2030?