S
smithers2002
My formula calculation appears in the cell rather than the result/value- why
is this happening, and how can I stop this?
Thanks
is this happening, and how can I stop this?
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
bj
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
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
D
Duke Carey
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
(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
M
MParham-Business
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.