Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Exporting adds a character
I am currently working in an access database (i know this is an excel
discussion group, im getting to that.) I have an excel page that is full of formulas, that i really want to be able to use, but i need to work out of access. Now, i can export directly into the excel page that i want to use, but the problem there is that every cell has an extra character added at the beginning of the data. For numbered values its fine, but for all the general values there is an apostrophe added. Is there a formatting issue that i need to work out? I have this question in the access database too, but noone seems to know what to do. If someone could help that would be great. Thanks. |
#2
|
|||
|
|||
Stuart
Try this........ With the Excel workbook open go to ToolsOptionsTransition and uncheck "Transition Navigation Keys" if checked. Gord Dibben Excel MVP On Wed, 11 May 2005 08:52:03 -0700, Stuart Y. wrote: I am currently working in an access database (i know this is an excel discussion group, im getting to that.) I have an excel page that is full of formulas, that i really want to be able to use, but i need to work out of access. Now, i can export directly into the excel page that i want to use, but the problem there is that every cell has an extra character added at the beginning of the data. For numbered values its fine, but for all the general values there is an apostrophe added. Is there a formatting issue that i need to work out? I have this question in the access database too, but noone seems to know what to do. If someone could help that would be great. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exporting Data to Excel-Date Format Changed | Excel Discussion (Misc queries) | |||
install Office Assistant character file? | Excel Discussion (Misc queries) | |||
Copy a column in worksheet with a character change | Excel Worksheet Functions | |||
Searching a cell for a certain character. | Excel Worksheet Functions | |||
Removing ' character from cells | Excel Discussion (Misc queries) |