A
Alex
Anyone know why I get a single quote in front of my data when I export to
Excel?
Excel?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
V
Van T. Dinh
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.
regardless of the characters following. For example, if all the following
characters are digits, Excell still treat the String as Text, not Numeric.
A
Alex
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?
V
Van T. Dinh
Sorry, I am not aware of any other ways besides CSV.
HTH
Van T. Dinh
MVP (Access)
HTH
Van T. Dinh
MVP (Access)
J
Jamie Collins
Alex said: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?
Jamie.
--