Excel Worksheet Sum Function

  • Thread starter Thread starter Alana
  • Start date Start date
A

Alana

I have an Access database that I do a query on. When I
select all and copy the query table, then paste into a pre-
existing workbook, the functions don't work. For example,
when I try to sum a column, I get zero. But if I go below
the pasted cells, and type in numbers, it will sum the new
entries.

The orignal Access database and workbook were created in
Office 2000. I am now using Office XP.
 
Probably because you get text numbers, make sure the import is general or
number format, copy an empty cell, select the imports, do edit>paste special
and select add
 
Alana

The data was brought over in Text format.

Re-format the cells as General then copy a blank cell.

Select the range of data and Paste Special>Add>OK>Esc.

Numbers should now be numbers.

Gord Dibben Excel MVP
 
Back
Top