title: SSIS 2008, Excel 2007 formatting excel columns properly (Exporting, not importing)
body: <p>I'm running into some formatting issues with exporting data to an excel 2007 spreadsheet.</p>
  
  <p>I have a template file that has the columns formatted correctly, but when the data is exported it doesn't get the correct formats (currency, short date, etc.)</p>
  
  <p>I'm thinking I have 2 options</p>
  
  <p>Have excel autorun a macro.  (hate that idea)</p>
  
  <p>Format the data before it gets to excel and make it string data only. (I don't like that idea either as you are going to get those irritating data conversion arrows next to each cell)</p>
  
  <p>I've used the IMEX=1 trick to get around the data import issues before, but is there a special trick for exporting?</p>
  
  <p>thanks,</p>