title: Formating a date in excel when combining text from multiple cells
body: <p>I have an excel sheet with some text in numerous cells and need to combine them into one cell. Easy, except one of the cells is a date and when combining the text you get the date in base number format and not in date format.</p>
  
  <p>Example:</p>
  
  <p>A1 = <code>"One"</code> 
  A2 = <code>"Two"</code> 
  A3 = <code>"05.12.2012"</code>
  A4 = <code>=A1&amp;" "&amp;A2&amp;" "&amp;A3</code> = <code>"One Two 41248"</code></p>
  
  <p>Anyone know what I need to do before A3 in order for the formula to return 05.12.2012 instead of 41248. I have tried "DATE" and "DATEVALUE" etc.</p>
  
  <p>If it is relevent, the date is derived from a formula which looks for a value in an array. I have left out this forumla for ease of reading.</p>