Thanks Elkar. I actually checked both of those. I also closed and opened
the spreadsheet. Still nothing. Closing and opening it a third time however
fixed it. Maybe I wasn't patting my head at the right speed.

"Elkar" wrote:

Based on what you've mentioned, I'd suspect that your cell formatting has
been set to "0". Thus, yes, everything would in fact display as 0. Check
the Cell Formatting, and change to 0 (no quotes) or General, etc...

Another possibility to check, is make sure Automatic Calculations is turned
on.
TOOLS--OPTIONS--CALCULATION Tab--Check Automatic

HTH,
Elkar


"CWillis" wrote:

I have a workbook I have been using all day. All of the sudden, everything
equals zero. Well, anything with an equals sign in front of it that is.
(Except column B, that one is fine.)

I'm not sure examples are needed, but just in case:

=1+1 gives "0"
=A1 gives "0"
etc.

Anyone know why/How to fix this?
-Chris