Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add a column of numbers (auto sum)??
When I highlight a column of numbers, I get the right formula, but return a
value of 0?? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add a column of numbers (auto sum)??
So you get something like =SUM(A1:A10) but this displays 0?
Sounds like they are not really numbers but text Try 1) format the range as numbers 2) copy an empty cell, select the range of interest and use Edit | Paste Special with Add specified --this trick converts text digits to numbers most of the time 3) if all else fails, after formatting the range as numbers, retype the numbers best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "tonysaw" wrote in message ... When I highlight a column of numbers, I get the right formula, but return a value of 0?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto sum only adding the last few numbers in the column. | Excel Worksheet Functions | |||
auto sum column containing words and numbers | Excel Worksheet Functions | |||
How can I auto refresh a column that has an auto filter in place | Excel Discussion (Misc queries) | |||
Auto generate numbers in decending order in a column | New Users to Excel | |||
How do I get auto fill to do decending numbers in a column? | Excel Discussion (Misc queries) |