Why is my formula appearing in the cell not the value?

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

Guest

My formula calculation appears in the cell rather than the result/value- why
is this happening, and how can I stop this?

Thanks
 
check if the cell is formated as text
check to see if <tools><options><view> has formulas checked.

if it is still showing the formula
select the equals sign and replace it.
If noe of thes work, I don't know
 
If it's the entire spreadsheet that is behaving that way, press the Ctrl-~
(Ctrl-tilde) key combination. If it's a single cell or range of cells, they
are formatted as Text. Change their format to some Number format, using the
Format->Cells menu options
 
My formula calculation appears in the cell rather than the result/value- why
is this happening, and how can I stop this?

ThankI am not sure why it does it but when it happens to me, I highlight the cells that I want to put the formula in and select EDIT - CLEAR - ALL and then enter the formula and it works. You may have to re-do the formatting.
Click to expand...
 
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

Formulas displayed in cell rather than calculated values? 4
Why does forumula show in cell instead of formula result? 2
Cell reference in formula string displays abbreviated value 2
Scrabble Value calculation for Welsh words 0
Excel formula, sum the value cell and if empty cell left blank 0
zero value in cell 2
Excel VBA 1
Show the formula not the result 3

Back
Top