summation won't work after export

  • Thread starter Thread starter Les Coover
  • Start date Start date
L

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
 
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.
 
Thanks, I appreciate the help

Les


Earl Kiosterud said:
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.
Click to expand...
 
Back
Top