formula is shown instead of calculating...?

[dawn]

I'm working on a worksheet to calculate pricing, and a few of the cells with formulas don't calculate, but instead just display the entire formula. I noticed that one cell with a formula was working properly, but when I double-clicked to adjust the formula and then "entered," the formula no longer gave me the answer, but listed the formula. I can't figure out how to correct it without "un-doing" it. It is formatted as "general", and still doesn't work. (Some formulas work. cntl+~ didn't help - thanks though!)
This message was edited by dawn on 2002-04-12 14:25
This message was edited by dawn on 2002-04-12 14:35

 

[Juan Pablo González]

The most common thing is that THAT cell is formatted as "Text". Change that to "General" (Or something else), edit the formula, press Enter, and you should see the result.

 

[EdE]

Try hitting ctrl+~. It may be that show formulas is selected.

 

[jpegb]

Hi Dawn
Use Edit/Clear/All, then put the formula in again.

 

[lynn]

This is a glitch in Excel 2000. If you formula refers to a cell which is formatted as text, it will switch your formula cell to text also. I think what you do is first format your formula cell to general (or whatever you need it to be), then hit F2 (or was it ctrl F2?). The answer is on Microsoft Support's site if that's not exactly the solution. Good luck Dawn!