 <p>You can set the <strong>NumberFormat</strong> of the cell:</p> <p><code>Range("E" &amp; destRow).NumberFormat = "m/d/yyyy"</code></p> <p><strong>EDIT</strong></p> <p>The value itself <strong>won't</strong> change. You could "cut" the value:</p> <pre><code>Left(Range("E" &amp; destRow).Value, 10) </code></pre>