Excel 2007 : Simple formula no longer works!???

[mgo61]

I have a formula which worked before and no longer works. It worked before and I'm positive it's correct because it's simply an addition of cells (which I've done a thousand times). The cell which displays the sum is equal to zero?? In other words, for simplicity sake, I'm adding 1+1 and coming up with zero. It's as simple as that. Did the cell possibly become corrupted? This has happened in a couple of cells on the same worksheet. I've tried erasing and inputting the formula again, but no luck. Any help would be greatly appreciated. Thanks.

[shg]

Welcome to the forum, mgo.

Please read the forum rules about thread titles, and then amend yours accordingly.

[JBeaucaire]

Click on GO ADVANCED and use the paperclip icon to post up your sheet that is misbehaving so we can examine these troublesome cells. Highlight them if they are not obvious.