Exporting adds a character

[Guest]

Hi, I am working on a database that i want to be able to export a table from
into excel. When i do this (I made a macro that exports it to a certain file)
it adds a character to the beggining of each cell. Its just a ' but it makes
all of my current formulas defunct. Is there anyways to avoid this? I need
the information to makes the formulas work well. Thanks

 

[Arvin Meyer]

You cannot export a formula (expression) from Access. The apostophe
character in Excel is put there to indicate that it is text.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Im not trying to export a formula (expression) im just trying to export the
date. I know that the apostrophe denotes the data as text, what i want to
know is, Can you make it so the ' isnt there. It makes all my formulas
(expressions [in excel]) useless.

 

[Guest]

Im not trying to export a formula (expression) im just trying to export the
date. I know that the apostrophe denotes the data as text, what i want to
know is, Can you make it so the ' isnt there. It makes all my formulas
(expressions [in excel]) useless.

And by date, i mean data. Thanks

 

[Arvin Meyer]

You may want to try asking in an Excel newsgrroup.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

Im not trying to export a formula (expression) im just trying to export the
date. I know that the apostrophe denotes the data as text, what i want to
know is, Can you make it so the ' isnt there. It makes all my formulas
(expressions [in excel]) useless.

And by date, i mean data. Thanks