title: Saving number as text, how to automate it
body: <p>I have a <code>7702216772</code> number inside a cell. If I put a <code>'</code> before the fist digit and click <code>Enter</code> <code>Excel</code> transforms the number to a text and puts a green triangle at the left top of the cell:</p>
  
  <p><a href="https://i.stack.imgur.com/Z637K.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Z637K.png" alt="enter image description here"></a></p>
  
  <p>I have many rows of similar numbers all of which need to be transformed into text. However clicking each and adding <code>'</code> before the first symbol and clicking <code>Enter</code> would take a lot of time. Is there any way to do it programatically?</p>
  
  <p>I tried using formula: <code>="'"&amp;H4</code> but it doesn't do what's expected - the green triangle never appears on the result cell.</p>
  
  <p><strong>I also tried setting cell format to Text, but the green triangle doesn't appear in that case too.</strong></p>
  
  <p><strong>I need the green triangle to appear at the upper left corner, just like at the picture!</strong></p>