Do the helpfile, tour, or knowledge base state anywhere that a cell has to be
formatted General before you enter a formula for it to work? Because I spent
hours searching and trying different things today, before customer service
told to me about this forum. It took me about three searches to find my
answer: delete, format, re-enter. Voila!

I couldn't believe that none of my searches from within Excel or on the
Office website (formulas not working, formulas not displayed, formulas shown
as text, worksheet not detecting formulas, format formula cell... ) mentioned
the possibility. I've had the problem before without finding the answer. I
thought at the time, that it was a result of some other problems on my old
computer, especially when it went away later. I must have tried using a
different area of the worksheet that I had not previously formatted. This
time no matter where I tried I could not enter any new functions. I had
selected the whole sheet and formatted it Text previously. I won't do that
again.

Maybe the requirement is stated somewhere already, but I believe it should
be easier to find it when someone is having this problem. I think it should
be stated in the Enter a Formula or Using Formulas pages. "Make sure the
cells are formatted General before entering formulas."

BTW, this community forum is Great!


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions