Text formula results do not display - Formula is UNchecked in View

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Even though the Formulas checkbox is unchecked under Tools - Options - View, my worksheet will not display results for Text formulas. Any suggestions welcome!
 
Hi
also check the cell format ('Format - cells'). Cnage this format to
'General' and re-enter your formula
 
You must log in or register to reply here.

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

formula displays as a formula, not as its result 1
E2007 formulas display as formulas, not results 3
Formulas displayed in cell rather than calculated values? 4
Display formula on the cell 2
Displaying Cell Formulas (without using Tools/Options/View-Formula 6
Print Value and Formula View worksheets 1
Excel VBA 1
Cell reference in formula string displays abbreviated value 2

Back
Top