Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers in a column won't add up
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?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers in a column won't add up
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 "Duane" wrote: 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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing A Column Of Text numbers To True Numbers: How ? | New Users to Excel | |||
Excel, change column of negative numbers to positive numbers? | New Users to Excel | |||
Can I change a column of calculated numbers to absolute numbers? | Excel Discussion (Misc queries) | |||
Changing column of numbers made of formulas to just numbers | Excel Discussion (Misc queries) | |||
Excel Formula - Add column of numbers but ignore negative numbers | Excel Worksheet Functions |