Copy field from Access to Excel

S

Steven

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
 
S

strive4peace

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
*
 
Top