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.