Editing cell and showing value

  • Thread starter Thread starter John Pappas
  • Start date Start date
J

John Pappas

My problem is editing inside a cell that contains a nested if formula.
After editing the cell and pressing return the cell places the 'formula' and
not the 'value resulting from the formula' in the cell. I keep checking if
it is protected but to no avail. Does anyone have any thioughts on this?
Thanks in advance.

John
 
Try changing the format of the cell to Number (or anything but Text).
(Format|Cells|Number tab)

Then select that cell, hit F2 and enter (to reenter the 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

Conditional formatting based on formula cell 6
add new value with previous in same cell 2
Excel formula, sum the value cell and if empty cell left blank 0
Lookup function to cell containing multiple values 3
Count Values in a Range, Not Formulas 2
Hide zero values 2
Excel Need Countifs Formula Help 0
AND IF STATEMENT 1

Back
Top