Pasting numbers from Access to Excel

J

jrh

In Access 97, I could open a query and copy all or certain
rows to paste into Excel. When I pasted them into Excel,
the numbers were pasted as numeric. With Access 2002 when
I paste numbers into excel, they are formatted at General
and I have to do a Text to Columns to format the data as
numeric.

Is there an option that I need to change?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embed the same Excel multiple times 0
Paste to excel from word - auto format problem 1
Merging from an Excel file with graphics 1
Pages are changing pasted image... 0
Excel does not accept text format! 0
Autonumber field in Excel that behaves the same as Access 0
Pasting a cell into bookmarked table from excel vba 1
Change a great number of words in word files, with a macro as short as possible. 5

Top