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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?!
 
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?!
 
You must log in or register to reply here.

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

Paste Formula 4
Why this paste result? 4
Time Sum in Excel 1
Problem Pasting Data 2
Line Feed in Formula Adds Double Quotes? 3
Convert text numbers to numbers 4
Analyze with excel (change access date format) 4
Sort Not Working on Column of Numbers 4

Back
Top