Quote:
Originally Posted by Raekwon
Maybe someone can help me out.
We have a spreadsheet imported from our phone system, yesterday users could highlight cells and autosum average and get average numbers. Excel updated and today no matter what I try on those cells I get #DIV/0! but if I type anywhere else on the same spreadsheet and try it works fine making me think Excel isn't seeing the numbers correctly. I tried a copy/paste multiply by 1 to force numbers to change and also copy paste to another blank section and back and still nothing. Any ideas?
Edit: Also if I just =sum them it always totals 0 which would cause the above error so Excel thinks all the values are 0 for some reason
|
Check the number format of the problem cell - is it formatted as text instead of a number?