title: Copying CSV Value changes the format
body: <p>I try to loop over a folder which contains (n) .CSV Files (These files are already imported and separated (Splitted)).</p>
  
  <p>i Copy  specific Columns (S:V) from the sources files to my Workbook (Makrofile.xlsm). </p>
  
  <p>The Problem : </p>
  
  <p>The Format of Numbers in Sourcefiles is : for Example 5,8987 after Copying these Numbers and Pasting them, the format changes to 558.97</p>
  
  <p>in the best Case after changing  the Format before copying from the Sourcefile i change the format to </p>
  
  <p>Columns("S:S").Select
  Selection.NumberFormat = "0.000"</p>
  
  <p>Then Copy and Close The Sourcefile then i paste to my (Makrofile.xlsm) The result is : 5.5897 </p>
  
  <p>I have a German Excel and the comma ist (,).I cant do Operations with this Number . </p>
  
  <p>Any Idea to keep the format of Values from the CSV as it is after pasting ? </p>
  
  <p>Thank You all very Much </p>