| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copying figures from Access to Excel
I am running Office 2002. When I tried to copy figures from a crosstab query in Access into Excel, the figures come in as text. This doesn't happen when using Office 2000 (on another PC). There is a convoluted way of converting the text to figures. However, is there a way of preventing this happening i.e. that the figures would copy to Excel as figures. Perhaps some setting need to be changed. Any help welcome.
mjd |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Financial modelling from Excel to Access | Excel Discussion (Misc queries) | |||
| Importing EXCEL Spreadsheets into ACCESS -- Macro or VBA? | Excel Worksheet Functions | |||
| Using Access in Excel VB Code | Excel Discussion (Misc queries) | |||
| Copying Text from Access to Excel - Data Lost | Excel Discussion (Misc queries) | |||
| Excel and Access talking | Excel Discussion (Misc queries) | |||
Linear Mode
