Numbers in a column won't add up

[Duane]

We use ACCESS to export schedules in to Excel. When we try to run Excel to
add up a column of numbers, the column will never add up. The only way that
we can do this is to manually replace each number in the column, then run the
formula again.

We have tried to change the format of the number in the cell to everything,
Number, Currency, Accounting, but none will work. The numbers are 1.00,
1.25, these types of digits.

Any ideas on why Excel will not add numbers that are exported from ACCESS??

 

[Mike H]

Duane,

Maybe the numbers are really text. Try this. Put a 1 (one) in a cell and
copy it. Select these 'numbers', Right click and select 'Paste Special'.
Select 'Multiply' and click OK and then see if they will add up.

Mike