title: Macro to Convert Column cells "Number saved as Text" to Number Format
body: <p>I tried the following but it's not working:</p>
  
  <pre><code>Sub Enter_Values3()
  Dim dbl As Double
  dbl = ThisWorkbook.Worksheets(2).Columns("A:A").Select
  End Sub
  </code></pre>