title: How to concatenate date in Excel 2010
body: <p>I have a question about concatenating a Date column (datetime) type in Excel 2010. For some reason, when concatenating Date, the values show as numbers. Below is my attempt to concatenate it.</p>
  
  <p>Given two columns in Excel 2010</p>
  
  <pre><code>Date                        ID
  2/22/2010 12:00:00 AM       1
  6/27/2001 12:41:30 PM       2
  3/11/2004  9:00:00 AM       3
  </code></pre>
  
  <p>Here, I am using the CONCATENATE function to concatenate two columns into a #temp table but the values in Date show as below</p>
  
  <pre><code>INSERT INTO #temp VALUES ('40231','1')
  INSERT INTO #temp VALUES ('37069.5288194444','2')
  INSERT INTO #temp VALUES ('38057.375','3')
  </code></pre>
  
  <p>Is there a way in Excel 2010 that I can use to concatenate exactly what I wanted which is like column Date above?</p>