title: Deleting a ' from a cell which is not being retrieved in .Value in VBA
body: <p>I need to find out how to delete a ' which is at the very beginning of every cell in the A column in a Excel but I can't figure out how to do it.</p>
  
  <p><a href="https://i.stack.imgur.com/nivaI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nivaI.png" alt="enter image description here"></a></p>
  
  <p>If I perform a Replace with</p>
  
  <pre><code>Replace(ActiveWorkbook.Worksheets("MAIN").Cells(2, 1).Value, "'", "")
  </code></pre>
  
  <p>or just showing the cell value with a MsgBox it just shows the number itself, without the '.</p>
  
  <p>Any idea about how to delete that character if I couldn't even access it?</p>
  
  <p>P.S: I've tried a basic "find and replace" with same result, even saying I have no matches...</p>
  
  <p>Thanks in advance.</p>
  
  <p>EDIT: Pressing F2 on the "A2" cell to see the formula shows this:
  <a href="https://i.stack.imgur.com/e7Hho.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/e7Hho.png" alt="enter image description here"></a></p>