I imported a table from Access (2003) into Excel (2003). A column that
contains numbers do not add correctly using the SUM function; however, it
adds correctly if I enter the formula as =A1+A2+A3+A4.

I know that data stored in Access may not be stored the same in Excel after
import. But even if I format the data in Excel (e.g., to Number), it still
does not calculate correctly using the SUM function.

"EbonLinctus" wrote:
A column that contains numbers do not add correctly
using the SUM function; however, it adds correctly
if I enter the formula as =A1+A2+A3+A4.
[....]
But even if I format the data in Excel (e.g., to Number),
it still does not calculate correctly using the SUM function.

Some or all of the cells are probably contain text. You can confirm this
entering =TYPE(A1) in a parallel column and copying down through A4 (or
whatever). If the result is 2 somewhere, the cell contains text.

Changing the format to Number does not change the type of the content. You
can put the number 1 into a cell, copy it, then select the cells containing
text, right-click and press Paste Special Multiply OK.




"EbonLinctus" wrote:
I imported a table from Access (2003) into Excel (2003). A column that
contains numbers do not add correctly using the SUM function; however, it
adds correctly if I enter the formula as =A1+A2+A3+A4.

I know that data stored in Access may not be stored the same in Excel after
import. But even if I format the data in Excel (e.g., to Number), it still
does not calculate correctly using the SUM function.