functions showing as text

[mehlerak]

I have a spreadsheet that at some point began displaying
=SUM(E140) instead of calculating the actual formula. This is happening for a large number of cells in the spreadsheet (not one in particular). I have also seen this on other spreadsheets and cannot figure out how to get my sums back. Excel seems to recognize as a formula (if I don't put in arguments, I get an error message), and this seems to be happening to all formulas (I tried a few with the same results). Using Excel2000.

Thanks

 

[AnotherHiggins]

Try pressing [Ctrl] + [`] (the key to the left of the 1 at the top of the keyboard).

[tt]_____
[blue]-John[/blue]
[/tt][red]Quidquid latine dictum sit, altum viditur[/red]

Help us help you. Please read FAQ181-2886 before posting.