Ahhh. I should have read the original post.

I bet your numbers aren't really numbers--they're text masquerading as numbers.
Changing the format of a cell doesn't change the underlying value.

If you put
=count(e4:e38)
what do you see?

This should count all the entries that are numeric.

If you see 0 with this formula, then maybe your data has extra stuff in the
cell.

Depending on what it is, there are different ways of cleaning this up.

David McRitchie has a macro:
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
(look for "Sub Trimall()")

And if you're new to macros, you may want to read David's intro:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

===
If that doesn't clean up all the data, you can use Chip Pearson's CellView Addin
to find out what's really in the cells:

http://www.cpearson.com/excel/CellView.aspx

jzkall wrote:

Still didn't work. Ugh, this is so frustrating. How can something as simple
as basic formulas cause this much headache!

"Dave Peterson" wrote:

Maybe you could try this:

Select all the cells
Edit|Replace
what: = (equal sign)
with: =
replace all

Excel should see this as a change to each formula and reevaluate each.

jzkall wrote:

Formulas are not calculating at all (they did previously). This is happening in
several different spreadsheets. It's almost as if formula calculating is
turned off. For example, I have this formula =SUM(E4:E38), which is
returning a zero although there is plenty of data in that range (which are
basic numbers).

I had checked some other posts, and verified that my Calculations are set to
'Automatic, and that numbers are set to to 'General'.

I also opened the same spreadsheet on someone else's computer, and it worked
fine. So it might be specific to my settings, I just can't figure out what it
is I did to change them. Thanks!!

--

Dave Peterson


--

Dave Peterson