Formula appears not result.

  • Thread starter Thread starter Mike Klick
  • Start date Start date
M

Mike Klick

I have a cell in Custom format mmmm d, yyyy. In similar cell below I try to
add one day to it: example: =E355+1. E355 being previous cell.

Instead of the result showing the Formula does. Why? This did work and
suddenly changed.

Thanks,

Mike
 
Hi
1. check if this cell is not formated as 'Text' (though this seems not
to be the problem)
2. Goto 'Tools - Options - View' and make sure 'Formulas' is not
checked
 
Thanks Frank.

Second one was it. Someone must have changed it.

Mike
 
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
Why does forumula show in cell instead of formula result? 2
formula errors 2
Formula result not appearing in Cell 1
Offset a formula result 1
Despite formula I use (for example SUM) result is always zero. 4
Show the formula not the result 3
cell displays 0 when formula is valid 2

Back
Top