Copy field from Access to Excel

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

Guest

I have a form based on a query where one of the fields is a number. I want
to copy a single field from the form in Access to Excel, but when I Paste
the value Excel delimts the value to separate cells, delimiting the value on
the comma. I am thinking it has to be a format setup of that field of the
Access Form. I have tried many things with no sucess. What do I do so the
number will copy correctly to Excel?

Thank you for your help.

Steven
 
Hi Steven,

try this:

before you Paste, enter a single quote mark '
and paste into the Formula bar

if you want the number to be a number you can perform mathmatical
operations on, you won't want to do this if the commas are to seperate
the thousands... you WILL want to get rid of the commas so Excel sees it
as a number... perhaps a command button to do the copy so the commas are
stripped.

How is the data stored that you are copying? As a number or as text?

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
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

Copy record info into new form 0
Access #Error & Excel Pivot 0
Use field to update multiple fields 4
Access Form - Lock Fields from Editing 0
Pasting email address into text field 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Copy Field from Prior Record 1
Export Account Number To Clipboard 4

Back
Top