View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey
 
Posts: n/a
Default Help! data from pasted table is not included in sum

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!