Numbers in a column won't add up

D

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??
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Numbers showing Up Centered in Cell ? 1
Macro to add numbers in a text string 5
formula for finding numbers that add up to a spicific number 1
decimals do not line up in column formatted the same 6
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
Sequentially adding a day to total 3
How doo I add letters or numbers to a whole column of part #s 1
duplicate numbers in a column 2

Top