title: Concatenate variable with leading zeroes with another string
body: <p><strong>Scenario</strong></p>
  <p>I have an excel cell that contains value with leading zereos (Eg: 0002). My macro is copying this value to a variable called <code>runNumber</code> and pasting it into another file by concatenating this <code>runNumber</code> with some other string. But when it does that, I am missing the leading zeros of <code>runNumber</code></p>
  <p><strong>Codes</strong></p>
  <p><code>yearInYy = &quot;19&quot;</code></p>
  <p><code>ciNumber = &quot;PFTPA-&quot; &amp; yearInYy &amp; &quot;-&quot; &amp; runNumber</code></p>
  <p>Output cell showing as <code>PFTPA-19-2</code></p>
  <p><strong>What I need</strong></p>
  <p>I need the output cell to show</p>
  <p><code>PFTPA-19-0002</code></p>
  <p>Anyone knows how to do it?</p>