title: Re-opened .csv file changes the value of 0.000E+00 number format
body: <p>I have an excel file where the data is extracted, Column A in the sheet is a 12 digit number which is saved as text in that columns. See below</p>
  
  <p>[<img src="https://i.stack.imgur.com/CBvxA.jpg" alt="1]"></p>
  
  <p>Further I have a macro build as this file is to be uploaded on web in .csv format which requires few formating to the file too. where the column is converted to 0.000E+00 format and than saved as .csv</p>
  
  <p>The below macro does the required formatting and converts the numbers to 0.000E+00 perfectly. <strong>But when i re-open the .csv file again the numbers are changed</strong> </p>
  
  <pre><code>Sub ECRformat()
  Dim LR1 As Long
  Dim LC1 As Long
  Dim rng As Range
  
  Application.ScreenUpdating = False
  Application.DisplayAlerts = False
  
  Workbooks.Open Filename:="C:\Users\Apple\Desktop\Salary software - Parikh constructions\Base files shared\ECR-WebUpload.xlsx"
  Windows("ECR-WebUpload.xlsx").Activate
  Sheets("ECR").Select
  Rows("1:1").Select
  Selection.Delete
  
  Windows("ECR-WebUpload.xlsx").Activate
  Sheets("ECR").Select
  LR1 = ActiveSheet.Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
  LC1 = ActiveSheet.Range("A1").CurrentRegion.Columns.Count
  
  Set rng = Range(Cells(1, 1), Cells(LR1, 1))
  rng.Select
  With Selection
      .NumberFormat = "0.000E+00"
      .value = .value
  End With
  
  Range("A1").Select
  
  ActiveWorkbook.SaveAs Filename:="C:\Users\Apple\Desktop\Salary software - Parikh constructions\Base files shared\ECR-WebUpload.csv", _
      FileFormat:=xlCSV, CreateBackup:=False
  ActiveWorkbook.Save
  ActiveWindow.Close
  End Sub
  </code></pre>
  
  <p>Eg : 100199847300 is converted to 1.002E+11 when saved as .csv
  <strong>When i re-open the .csv file the value are changed to 1.00E+11 and shows 100200000000.</strong></p>