formatting an number field in Excel exporting from a SQL DTS

[goldwhispers]

I am having problems exporting numeric data from a SQL DTS into an excel file, the numeric data (even though i tried to specify with numeric and with decimal, it still comes into the excel file with an ' infront of the values and i can't even reformat it properly without creatinga new column and going =value() kind of thing...has anyone had this problem before?

 

[leveyp]

Did you create the worksheet first? Try creating an empty workbok and letting DTS create the destination table (worksheet) In my test, numeric(11,2) was converted to 'double' without any problem.