Thanks Duke-
It didn't work, though I tried several versions of your advice. What I
finally did was go back to the word doc, copy the column of numbers from the
table inside the word doc, selecting to keep text only. with it in that
format I was able to copy and paste into excell with no problem. Must have
been some glitch with the table formatting in word and the formatting in
excell.
I so appreciate your help!

"Duke Carey" wrote:

Most likely Excel treated the numbers as labels. To convert them to numbers,
copy an empty cell, select the pasted range, use Edit-Paste Special-Add and
Values, click on OK


"campli" wrote:

I pasted a column of simple numbers from a word doc to an excell spreadsheet.
When I try to find sum of cell range, pasted data (although visible) is not
included. I'm sure you are all saying "duh!" but I'm sooo frustrated!
Help!