title: Confusing dd/mm/yyyy and mm/dd/yyyy
body: <p>I have a VBA script that opens up a bunch of CSV files, and compiles them into one summary report.</p>
  
  <p>However, I'm having a problem where it reads in UK style dates (dd/mm/yyyy), then interprets them as US-style dates when it makes the copy, before display them as UK-style dates again!</p>
  
  <p>So 4th of July in original sheet becomes 7th of April in the summary sheet - verified by changing cell format to display month name. </p>
  
  <p>This is odd, as when you open up the CSV file in Excel, it correctly interprets the UK style date.</p>
  
  <p>Copy is made using code like this</p>
  
  <pre><code>SummarySheet.Cells(Y,X).value = CSVSheet.Cells(W,Z).value
  </code></pre>
  
  <p>What is going on here?</p>