title: VBA: Convert Text to Number
body: <p>I have columns of numbers that, for whatever reason, are formatted as text. This prevents me from using arithmetic functions such as the subtotal function. What is the best way to convert these "text numbers" to true numbers?</p>
  
  <p>Here is a screenshot of the specific issue:
  <a href="https://i.stack.imgur.com/mW3qI.png" rel="noreferrer"><img src="https://i.stack.imgur.com/mW3qI.png" alt="Error"></a></p>
  
  <p>I've tried these snippets to no avail:</p>
  
  <pre><code>Columns(5).NumberFormat = "0"
  </code></pre>
  
  <p>and</p>
  
  <pre><code> Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
          :=False, Transpose:=False
  </code></pre>