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

[Guest]

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.

 

[Guest]

Hi
you may try after importing the following line of code

range.value=range.value

 

[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"

 

[Jamie Collins]

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

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.

--