Pasting Access numerical data into Excel

S

Sara

I'm using Access 2002 and Excel 97. With this new
version, whenever I copy data from Access and paste into
Excel, Excel recognizes the numbers as text. So I can't
do formulas, sort, etc. To fix this, I have to create a
formula to convince Excel it's a number (for example,
=A2+0, then this new field allows me to do formulas, sort,
etc, while the A2 cell wouldn't allow me to do that.

Any idea how to make a clean copy from Access to Excel
where Excel recognizes the data as being a number? Any
help would be appreciated!

Thanks,
Sara
 

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

Merging from an Excel file with graphics 1
Excel suddenly crippled by Just-In-Time Debugging 2
Linking data in MS Word into Excel 5
Populating a Text Field with a value in an Excel Sheet 0
Exporting to Excel 0
Pasting a cell into bookmarked table from excel vba 1
How To Rapidly Copy Formulas? 0
RTF data from Excel 2007 to Access 2007 1

Top