title: VBA copies string and pastes scientific notation
body: <p>I am having a problem with the below code.
  The code is supposed to copy long strings. 
  The source file has this  content as string. It is about 50 characters long. There are digits and letter mixed.</p>
  
  <p>The problem is that for some of the pasted ranges they are in scientific notation which cannot be looked up by the other functions.</p>
  
  <p>Here is the relevant section of the code</p>
  
  <pre><code>For i = 1 To Columns.Count        
      If Left(ActiveWorkbook.Sheets(1).Cells(7, i).Value, 4) = "1068" Then
          ActiveWorkbook.Sheets(1).Range(ActiveWorkbook.Sheets(1).Cells(7, i).End(xlUp), ActiveWorkbook.Sheets(1).Cells(7, i).End(xlDown)).Copy _
          Destination:=ThisWorkbook.Sheets(1).Cells(Rows.Count, 1).End(xlUp).Offset(1, 0)                   
      End If
  Next i
  </code></pre>
  
  <p>Is there a way to paste only values for such a range?
  I've tried with method "paste values" but got VBA error message</p>