Excel Worksheet Sum Function

[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.

 

[Peo Sjoblom]

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

 

[Gord Dibben]

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