title: Excel VBA: Preserve source formatting when modifying a formula
body: <p>I'm copying a date from one sheet to another like this:</p>
  
  <pre><code>Worksheets("MySheet1").Range("A1").Formula = Worksheets("MySheet2").Range("A1").Formula
  </code></pre>
  
  <p>The cell in 'MySheet1' shows the 5-digit value instead of the formatted date, despite that I pre-formatted the entire column.</p>
  
  <p>How do I preserve the formatting?</p>
  
  <p>Thanks</p>