title: word vba number format (percentage)
body: <p>I am trying to copy data from excel into word using vba codes. The values are in decimals, 0.02 or 0.04 but I would like to change it to 2% or 4%. I won't have rounding issues since the only values that are in the list is 0.01, 0.02, 0.03, 0.04 or 0.05.</p>
  
  <p>Here are my codes,</p>
  
  <pre><code>'new line
  .TypeParagraph
  .Font.Size = 10.5
  .TypeText Space(17)
  .TypeText Format(ws2.Range("L1").Value, "#%") &amp; Space(5) &amp; "Inforce: " &amp; ws12.Range("M56").Text &amp; " (" &amp; ws12.Range("N56").Text &amp; ")"
  </code></pre>
  
  <p>Now the codes seem to run through, by pressing F8, but it just doesnt produce 2% or 4% instead it is still showing as 0.02 or 0.04. I tried to change .value to .text but same result. There is no error, just not the desire result I am looking for.</p>
  
  <p>I am only pasting this portion of codes since the rest works fine.</p>
  
  <p><a href="https://i.stack.imgur.com/nG93L.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nG93L.png" alt="enter image description here"></a></p>