I have many DTS packages that export data to many excel
files, but in each cell there is a single quote (') before
the data in each cell which is causing errors when trying
to do calculations in excel and every field is
in "General" format in excel. How do i export data with
my DTS package to Excel and NOT have the single quote
appear in excel before the data in each cell?

Any help would be greatly appreciated.

What I think is happening to you is this

For text valued columns excel inserts a '

I just ran a test of exporting authors to an XL file. If you let DTS create the table in XL then it will define the "zip" field as a varchar. Pump to it and you will see that the zip field entries have a ' before them. Now I know that the data in
this field is numeric so I reran the test but instead edited the CREATE TABLE statement to say integer for the zip field instead of varchar.

All the ' go away now.




--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org