Everything equals zero

[0ddball]

I have a problem. One of my users has managed to do something to her copy of Excel and now everything equals zero.

So:
=SUM(A1:Z99) == 0
=4+6 == 0
=SUMIF(A1:A300, "",B1:B300) == 0

It doesn't matter what these ranges contain, it doesn't care. Everything equals 0.

Wait - here's the confusing part. The aggregate function provided by Excel (the quick lookup in the bottom right in the info bar) is working fine. That can count, average, sum, etc. and get it right.

Everything else - 0

The first thing you're going to jump on is "Ah - you're in manual calculation mode!". Nope - auto calc. I've even changed it to manual, saved, closed, opened, change it to auto-calc, saved, closed... 0.

Now I need more help - I'm completly baffled and stuck. As is the entire Tax department and the whole of Group IT.

Help!!!


Yet another unchecked rambling brought to you by:
Oddball

 

[AnotherHiggins]

After you press enter and the cell displays zero, click back on the cell - does the formula bar still show the formula, or just zero?

Is it only one workbook that is giving you trouble? Or if you create a brand new workbook and type in =4+6, will it still return zero?

Are there any macros open? Try changing the security level to Very High (Tools > Macro > Security), then creating a new workbook. What happens then?

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[TonyJollans]

This could be done by having a custom format of "0" applied to the sheet - although why anyone would want to do that, I can't imagine.

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website