view value instead of formula

G

Guest

Sometimes the formula displays in the cell instead of the value. How do I
get the cell to always show the value? I've tried the Ctrl + ` combination
but this doesn't seem to help in some of my spreadsheet. Is this a setting
I'm missing?

Thanks!!
 

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

Scrabble Value calculation for Welsh words 0
Match function: error due to format? 4
Formulas displayed in cell rather than calculated values? 4
Excel How to get output of the formula instead of True or false 1
Why does forumula show in cell instead of formula result? 2
Excel VBA 1
Display formulae instead of showing values in cells 3
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1

Top