title: Convert Number stored as Text to Number in column
body: <p>I have a column of mixed data in my Excel sheet where the numbers are formatted as &quot;Text&quot;.</p>
  <p>Some examples:</p>
  <ul>
  <li>36</li>
  <li>R4</li>
  <li>56</li>
  <li>AF PL RFD</li>
  <li>65</li>
  <li>DHU</li>
  <li>14</li>
  </ul>
  <p>I need to convert all the numeric values in the column to the format &quot;Number&quot; so I can further process the data.</p>
  <p>The following throws an error 400 without any further explanation:</p>
  <pre><code>Sheet1.Range(&quot;A2&quot;,&quot;A50000&quot;).Select
  With Selection
      .NumberFormat = &quot;General&quot;
      .Value = .Value
  End With
  </code></pre>
  <p>I don't how many rows with values my column will contain so I had to make the range fairly big.</p>