pasting Access 02 to Excel 02. numbers dont' work in formula

B

BXS

Working on an XP machine with Office 2002...sometimes for ease of creating
reports to users I copy from Access and paste into Excel. Numbers in general
DO NOT copy as numbers like the previous versions of Access and Excel. This
is quite annoying having to copy a column into Notepad only to copy it back
into Excel, then the TOTAL or any other math functions work.

Any Suggestions?!
 
L

Lady Layla

Use paste special


: Working on an XP machine with Office 2002...sometimes for ease of creating
: reports to users I copy from Access and paste into Excel. Numbers in general
: DO NOT copy as numbers like the previous versions of Access and Excel. This
: is quite annoying having to copy a column into Notepad only to copy it back
: into Excel, then the TOTAL or any other math functions work.
:
: Any Suggestions?!
 

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

Problem Pasting Data 2
Trim and Substitute not working 4
Analyze with excel (change access date format) 4
Copy and Paste Issues 2
Formula's won't read copy / pasted data ? 2
Number Formatting Issue 1
Convert text numbers to numbers 4
I cannot copy the columns of formulas in this Workbook::: AHHHHHHHHHHHHHHHH 6

Top