title: Why does my VBA script change the date format?
body: <p>I have a script set on a button so that it copies the date from a cell (put in by a date picker linked to the cell) to another cell in a different worksheet.</p>
  
  <p>My problem is that I want the date format to always be <code>dd/mm/yyyy</code>. At the moment, if I pick a date that is say <code>"28/03/2014"</code> then it will copy this date over exactly as it is. The issue comes when I pick a date like <code>"02/03/2014"</code>, this will now for some reason be converted to <code>"03/02/2014" (mm/dd/yyyy format)</code> when copied across. I don't know why it is happening and even more so, why it is only happening for dates that 'could' be correct either format. </p>
  
  <p>This is the code I am using to copy the date:</p>
  
  <pre><code>Worksheets("ActionPlan").Range("E" &amp; (ActiveCell.Row)).NumberFormat = "dd/mm/yyyy"
  Worksheets("ActionPlan").Range("E" &amp; (ActiveCell.Row)).Value = Worksheets("Update").Range("G3").Value
  </code></pre>