Formula won't display as cell set to Constant

G

Guest

I'm am having an issues with Excel 2002 - SP3 (XP)

I occasionally come across an issue where a formula won't display the value.
I.e - cell displays =N3-N4 rather than the answer. Using the watch window I
can see =N3-N4 is displayed in the text column rather than the formula
column. Also the evaluate formula tool tells me that the cell is displaying a
constant.

Please help!

Thanks
Laurence
 
G

Guest

If the cell is displaying the formula, it could be because the cell format is
TEXT. Check format and change to GENERAL if required and re-enter formula.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I reference a cell as a row number in a formula? 4
How do I fix: cell won't calculate because it is a constant? 1
Excel won't resolve formula in one column 3
How do I add a formula to a cell containing a constant value 2
Formula Audit mode active in one column only; cannot kill. 2
Display cell ref for MAX formula 7
Tricky LONG formula, need a shorter version, there has to be a way 7
Formula showing in cell as text 3

Top