title: Microsoft Excel Copy and Paste with Format of Date
body: <p>Can anyone help me with copying and pasting but keep the format of the data to be date for all the dates and numbers for all the numbers. So for example I have Customer ID which should be 3 digits (000), and date to be in date format. But when I copy and paste, the date became an weird integer and the ID become 1 digit. Here is the output now</p>
  
  <p>Copy from:</p>
  
  <p>001       AVC     BDE     130     6/23/2013</p>
  
  <p>When I paste it becomes:</p>
  
  <p>Cust ID   Name    Type    Amount  Date
  1     AVC     BDE     130     41448</p>
  
  <p>Can anyone help?
  Here is my code</p>
  
  <pre><code> ActiveSheet.Range("A1:F1").Copy
  wkbDisplayOrder.Worksheets("Customer's Order").Select
  ActiveSheet.Range("A1:F1").PasteSpecial Paste:=xlPasteValues
  </code></pre>