Exporting adds a character

S

Stuart Y.

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
 
S

Stuart Y.

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.
 
S

Stuart Y.

Stuart Y. said:
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.
Click to expand...

And by date, i mean data. Thanks
 
A

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

Stuart Y. said:
Stuart Y. said:
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.
Click to expand...

And by date, i mean data. Thanks
Click to expand...
 
Top