title: VBA excel paste as text
body: <p>I need to paste numbers as text. It is problematic due to lots of zeros in front (but I need them there). First snippet, does not work (I found it on the internet).</p>
  
  <pre><code>Worksheets("B").Range("k7:k7").PasteSpecial Format:=”Text”, 
  Link:=False, DisplayAsIcon:=False
  </code></pre>
  
  <p>The other I recorded, but it not always work. </p>
  
  <pre><code>PasteSpecial Paste:=xlPasteAllUsingSourceTheme, Operation:=xlNone, 
  SkipBlanks:=False, Transpose:=False
  </code></pre>
  
  <p>Could someone suggest me a better solution, please?</p>