odd character on export to excel

J

jculpepper

I do a query and choose the export option and save as an
excel spreadsheet. All data in each column is proceeded
by a ' character. It does not "find" in a find and
replace so I can get rid of it other than manually. Also,
I can't figure out a way to not have it appear.

Frankly I don't know if this is an access or excel
problem, a Report or Query newsgroup problem etc.

Anyone out there have an idea?

jc
 
Top