Leading ' in cell values when data is Exported to Excel 2002

J

Jimmy

Hello, when exporting data to Excel, all of the cells have a leading ' .
Any ideas on how to keep this from happening?

I have not seen this with earlier versions of Excel and am experiencing this
problem when Exporting data from WinRunner and from MS Access through VBA.

Much appreciated, thanks.
 
F

Frank Kabel

Hi
you may try after importing the following line of code

range.value=range.value
 
D

Dave Peterson

If you see that leading apostrophe in the formula bar, maybe it's just a setting
you have to toggle.

Tools|options|transition tab|uncheck "transition navigation keys"
 
J

Jamie Collins

Jimmy said:
Hello, when exporting data to Excel, all of the cells have a leading ' .
Any ideas on how to keep this from happening?
Click to expand...

This should only happen where the column's data type is text. This
behaviour is by design so that a cell of data type text that contains
only numeric characters is seen by Excel as text and not a numeric
value.

If the exported column *supposed* to be numeric (check you database
schema) but is appearing in Excel with leading apostrophes, then you
have a problem with your export.

Jamie.

--
 
Top