summation won't work after export

[Les Coover]

Excel and Access 2000 standalone PC

I exported a table from Access to Excel

For some reason the summation formula won't work.

If I use = A1 + A2 + A3 I get the correct result.

If I manually enter the numbers I exported in----- the Sum(range) works.

Any suggestions.

Les

 

[Earl Kiosterud]

Les,

The exports generally result in fields that are text, not numbers. A
formula with single-cell references will coerce them to numbers, but
functions like SUM do not. And Access fields are somtimes defined as text
fields, even when they'll contain numbers. Changing the Excel Number
formatting (text, number, etc) won't fix this -- they're still text.
Formatting does not change the data type in the cell

One way to convert cells from text to numbers is to put a 0 in a cell and
Copy it. Select the cells to be changed, Edit - Paste special, Add.

 

[Les Coover]

Thanks, I appreciate the help

Les

Les,

The exports generally result in fields that are text, not numbers. A
formula with single-cell references will coerce them to numbers, but
functions like SUM do not. And Access fields are somtimes defined as text
fields, even when they'll contain numbers. Changing the Excel Number
formatting (text, number, etc) won't fix this -- they're still text.
Formatting does not change the data type in the cell

One way to convert cells from text to numbers is to put a 0 in a cell and
Copy it. Select the cells to be changed, Edit - Paste special, Add.