Calculations not working on pasted values from Access

S

Scott Sullivan

I'm using Office 2000 on W2k, and when I copy and paste a
column of numbers from MS Access to MS Excel, I am unable
to perform a Sum function on the pasted values. The
function always returns zero. If I then type in the values
directly it does work. Anyone know why? Is this caused by
a virus and is there a patch?
 
P

Peo Sjoblom

It is because it is seen as text, try to copy an empty cell,
select the imported numbers, do edit>paste special and select add.
 
G

Guest

Thanks for the reply...I actually had tried pasting the
values as numbers before and that still is not working.
I've tried every paste option in the "Paste Special"
dialog box, but nothing works. that's why I was thinking
it was a virus since this was not previously happening to
me. any ideas??
 
D

Dave Peterson

Peo's suggestion was to do your paste first, then come back and copy an empty
cell.

Then select your range and do an Edit|Paste special|check Add.

Two different steps.

(Apologies if you tried that.)
 
J

jitensanghvi

The problem is that the numbers are being picked up as text and so no
operations can be performed on it. Try this method:
In an empty cell, enter the number 1.
Select the cell, and on the Edit menu, click Copy.
Select the range of numbers stored as text you want to convert.
On the Edit menu, click Paste Special.
Under Operation, click Multiply.
Click OK.
Delete the content of the cell entered in the first step.
Click to expand...

Please tell me if this solved your problem.
 
Top