title: VBA, Date formatting issue
body: <p>I have a code that </p>
  
  <p>1) compares dates from Col X to Col Y. </p>
  
  <p>2)paste dates to col Y if there is no match between columns. </p>
  
  <p>Column X my format looks like </p>
  
  <pre><code>08/15/2013
  09/12/2013
  10/03/2013
  </code></pre>
  
  <p>But when it pastes to column Y it goes,</p>
  
  <pre><code>15/08/2013
  12/09/2013
  03/10/2013
  </code></pre>
  
  <p>How can  I format my paste to go to dd/mm/yyyy.</p>
  
  <p><strong>Added more code to show array:</strong></p>
  
  <pre><code>   ReDim PasteArr(1 To 1, 1 To 6)
      subcount = 1
  
      For Cell1 = 1 To UBound(DataArr(), 1)
          For Each Cell2 In BusDates()
              If DataArr(Cell1, 1) Like Cell2 Then
                  Matched = True
                  Exit For                                      'if it matches it will exit
              ElseIf Cell2 Like BusDates(UBound(BusDates), 1) Then 'if it gets to the end, it's truly unique and needs to be added
  
                  For index = 1 To 6
                      PasteArr(subcount, index) = DataArr(Cell1, index)
                  Next index
  
                  subcount = subcount + 1
  
                  PasteArr = Application.Transpose(PasteArr)
                  ReDim Preserve PasteArr(1 To 6, 1 To subcount)
                  PasteArr = Application.Transpose(PasteArr)
  
                  Matched = False
  
              End If
          Next Cell2
  
          If Matched = False Then
              BusDates = Application.Transpose(BusDates)
              ReDim Preserve BusDates(1 To UBound(BusDates) + 1)
              BusDates = Application.Transpose(BusDates)
              BusDates(UBound(BusDates), 1) = DataArr(Cell1, 1)
          End If
  
      Next Cell1
      Worksheets("stacks").Range("M" &amp; LastRow + 1 &amp; ":" &amp; Cells(LastRow + UBound(PasteArr, 1) - 1, 18).Address).Value = PasteArr
  </code></pre>
  
  <p><strong>What i've tried: Changing the format of cells</strong></p>
  
  <p><a href="https://i.stack.imgur.com/y2HPh.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/y2HPh.jpg" alt="enter image description here"></a></p>
  
  <pre><code>15/08/2013
  12/09/2013
  03/10/2013
  </code></pre>
  
  <p>which is now the correct format for column X.</p>
  
  <p>But this is pasting into column Y as:</p>
  
  <p><a href="https://i.stack.imgur.com/zgfBl.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zgfBl.jpg" alt="enter image description here"></a></p>
  
  <p>which is </p>
  
  <pre><code>15/08/2013 - correct
  09/12/2013 - incorrect
  10/03/2013 - incorrect.
  </code></pre>