transfer data to Excel

K

ksewrpc

When I copy numeric data from Access and paste it into Excel, it comes up as text. How can I keep it numeric?
 
K

Ken Snell

Are you doing a Ctrl+C and then a Ctrl+V when you do the copy and paste?

If yes, then double-click in the Excel cell before you paste the data, and
then do Ctrl+V in the cell. Or click in the formula bar and paste the
numbers into that location.

--
Ken Snell
<MS ACCESS MVP>

ksewrpc said:
When I copy numeric data from Access and paste it into Excel, it comes up
Click to expand...
as text. How can I keep it numeric?
 

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

Create a dynamic master file 1
Embed the same Excel multiple times 0
Paste to excel from word - auto format problem 1
Merging from an Excel file with graphics 1
Auto match destination formatting for Mac 0
Cell data entering slow! 0
Linking data in MS Word into Excel 5
List all tables, including document structure 0

Top