L
Lisa
Hi there,
I'm experiencing a problem either with Access 2002 or
Excel 2002.
When I export an Access 2002 report containing
information such as i.e. 03-0001, 03-0002, 03-0005 listed
in a column, into Excel 2002, the text is automatically
changing to i.e. 37624, 37655, 37744 which is not wanted
(text should remain unchanged).
Funny thing is, it works fine when I export the Access
table or the query into Excel(the report is based on the
same query) - text remains as 03-0001, 03-0002, etc. Not
sure if the problem resides with Access or is Excel
trying to be too smart and automatically changing the
formatting of the cells. Perhaps it is just an option to
be set?
Help!
Lisa
I'm experiencing a problem either with Access 2002 or
Excel 2002.
When I export an Access 2002 report containing
information such as i.e. 03-0001, 03-0002, 03-0005 listed
in a column, into Excel 2002, the text is automatically
changing to i.e. 37624, 37655, 37744 which is not wanted
(text should remain unchanged).
Funny thing is, it works fine when I export the Access
table or the query into Excel(the report is based on the
same query) - text remains as 03-0001, 03-0002, etc. Not
sure if the problem resides with Access or is Excel
trying to be too smart and automatically changing the
formatting of the cells. Perhaps it is just an option to
be set?
Help!
Lisa