The single-quote is Excel flag to indicate the value is a Text value
regardless of the characters following. For example, if all the following
characters are digits, Excell still treat the String as Text, not Numeric.
Thanks Van.
I know about the quote as it's handled in Excel, I was wondering if there is
a way to get rid of it when one exports to Excel, without creating a CSV file?
I know about the quote as it's handled in Excel, I was wondering if there is
a way to get rid of it when one exports to Excel, without creating a CSV file?
It's a 'lowest common denominator' thing, just like always putting
square brackets around column/field names i.e. the intelligence isn't
there to check for illegal characters, reserved words etc, its easier
to always use brackets regardless.
How is the leading apostrophe causing you problems?
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
