Calculations not working on pasted values from Access

  • Thread starter Thread starter Scott Sullivan
  • Start date Start date
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?
 
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.
 
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??
 
Back
Top