title: How to format column to number format in Excel sheet?
body: <p>Below is the VBA code.  Sheet2 contains all of the values in general format.  After running the code, values in column 'C' of Sheet3 contain exponential values for numbers which are 13 or more digits.</p>
  
  <p>What should be done so that column 'C' of Sheet3 does not contain exponential values?</p>
  
  <pre><code>private Sub CommandButton1_Click()
  Dim i, j, k As Variant
  
   k = 1
  For i = 1 To 30000
  If Sheet2.Range("c" &amp; i).Value &gt;= 100 And Sheet2.Range("c" &amp; i).Value &lt; 1000 Then
  Sheet3.Range("a" &amp; k).Value = Sheet2.Range("a" &amp; i).Value
  Sheet3.Range("b" &amp; k).Value = Sheet2.Range("b" &amp; i).Value
  
  Sheet3.Range("c" &amp; k).Value = Sheet2.Range("c" &amp; i).Value
  
  k = k + 1
  End If
  Next
  
  End Sub
  </code></pre>