By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,784 Members | 1,188 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,784 IT Pros & Developers. It's quick & easy.

wierd export excel apostrophe problem

P: n/a
Hi all

Every time I export a table into an excel spreadsheet. It has a
leading apostrophe on every cells. This drive me nut. I have to do a
work around by export table into a txt file than import in excel to get
rid of the apostrophe.
It has been happen about two months now before it didn't do
that. It is only happen when I have text data type in the table. If I
change to number data type then the problem go away but most of my
tables have text data type.
After going through the archive, apostrophe mark is how excel
recognize as text data type. But it should remember hidden though.
Is there a seeting for me to get rid of the apostrophe?
Do I reall need to use VBA for this simple problem.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
but if someone else open the excel file he is going to see the leading
apostrophe that is very annoying. How do I take those apostrophe out
of the excel file.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.