title: Insert Text before a date and apply custom format for it
body: <p>I need to insert a text before a date, and the date must have a yymm format ([$-en-US]yymm;@) after the text (i.e. PSAAPV2003)</p>
  <p>So far I managed to do something like this:</p>
  <pre><code>Dim r As Range
      
      For Each r In rng
          If r.Value &lt;&gt; &quot;&quot; Then r.Value = &quot;PSAAPV&quot; &amp; r.Value
      Next
  </code></pre>
  <p>It is partially ok because de result is PSAAPV08.03.2020. It shows the entire date.</p>