I created an SSIS package that writes to an excel destination file. I succeeded in setting the formatting for different numeric columns. However I noticed that if a row has a null value in one of the formatted numeric columns, then all succeeding rows display the numeric data unformatted for the same column. Example: Each row of the spreadsheet contains the following columns: Name (character) NumOrders (integer - ###,### format) Sales (real - ###,###.## format) %Target (real - ##.#% format) Assume the following rows: Name1 12345 12345.67890 .8967 Name2 12345.67890 .8967 Name3 5678 .8967 Name4 7777 12345.67890 .8967 What appears in the resulting excel sheet is: Name1 12,345 12,345.68 89.7% Name2 12,345.68 89.7% Name3 5678 89.7% Name4 7777 12345.67890 89.7%

... I succeeded in setting the formatting for different numeric columns... What appears in the resulting excel sheet is: Name1 12,345 12,345.68 89.7% Name2 12,345.68 89.7% Name3 5678 89.7% Name4 7777 12345.67890 89.7% How did you set the formatting exactly? And how did you plan to treat the NULLs? Probably you did not plan to handle the NULLs, then substitute the NULL to 0.Arthur My Blog