campli

Most likely the numbers are "text"..

Format to General then copy a blank cell, select the cells and Paste
SpecialAddOKEsc.

Should now be numbers.


Gord Dibben MS Excel MVP

On Thu, 12 Jan 2006 10:12:02 -0800, 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!