Date value changes when copied
<p>I have cells containing a simple concatenation function with D24 as the previous year (e.g. 15) and a custom format (<strong>MMM JJ</strong>)</p>

<p><code>CONCATENATE("Apr ",$D$24)</code></p>

<p>When I am copying and pasting these cells with a VBA then "Apr 15" becomes "15.04.16" and because of the formatting "Apr 16"</p>

<p><code>Selection.Value = Selection.Value</code></p>

<p>Was is the reason behind this? Is there another solution than just changing the format to text?</p>