How do I replace the contents of a cell with its value instead of.

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

Guest

I cannot get the worksheet to display the value of the function instead of
the function itself.
 
tools, options, view tab, windows options at bottom,
formulas unchecked

Boris
 
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

Cell shows the last typed text, no matter where it is typed 0
If function across sheets prints value of cell 4
Excel How to get output of the formula instead of True or false 1
How do I VLookup visible cells only? 2
Excel formula, sum the value cell and if empty cell left blank 0
* instead of value 3
Display formulae instead of showing values in cells 3
Reference cell ID in CUBEVALUE tuple instead of actual value 1

Back
Top