Create your Excel workbook, format as required, then delete any data rows in it, then store a copy somewhere the DTS can access. Have an ActiveX delete the existing workbook, copy the new empty workbook to the same location then run the DTS task to transfer your data to the new empty workbook. Data goes in and adopts all the formatting applied to the original data...