title: How to read time stamp (DD/MM/YYYY) format from text file and correctly interpret it using Excel VBA?
body: <p>I need to write an Excel VBA program to read a text file and sort them by timestamp. Following is an example of the text file:</p>
  
  <pre>
  Time / Date ColumnB Column C
  3/03/2017 3:07  Value B2 Value C2
  3/02/2018 9:02  Value B4 Value C4
  16/02/2018 9:03 Value B5 Value C5
  17/02/2018 9:04 Value B6 Value C6
  
  (File Name: import_File.csv)
  </pre>
  
  <p>where the time / Date is in DD/MM/YYYY HH:MM format. </p>
  
  <p>However, when I try to open it in VBA, it have automatically interpreted the first column incorrectly by following American format (MM/DD/YYYY)</p>
  
  <pre>
  File            |Correct interpretation |VBA interpretation
  ----------------+-----------------------+---------------------------------
  3/03/2017 3:07  |3 Mar 2017 3:07:00     |3 Mar 2017 3:07
  3/02/2018 9:02  |3 Feb 2018 9:02:00     |2 Mar 2018 9:02
  16/02/2018 9:03 |16 Feb 2018  9:03:00   |"16/02/2018  9:03:00" as a text
  17/02/2018 9:04 |17 Feb 2018  9:04:00   |"17/02/2018  9:04" as a text
  
  
  </pre>
  
  <p>Following is how do I open the file:</p>
  
  <blockquote>
    <p>Set Data_File = Application.Workbooks.Open("import_File.csv", 3, True, 1)</p>
  </blockquote>
  
  <p>I do tried to use <em>Selection.NumberFormat = "dd/mm/yyyy hh:mm:ss"</em>, but it doesn't help at all as it have already interpreted the column incorrectly when it first come in.</p>
  
  <p>Should I need to open it as a text file first, then play around the timestamp myself? Or there is any quicker way to do the job.</p>
  
  <p>Thanks for your help!</p>