My formula calculation appears in the cell rather than the result/value- why
is this happening, and how can I stop this?
Thanks
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
"smithers2002" wrote:
> My formula calculation appears in the cell rather than the result/value- why
> is this happening, and how can I stop this?
>
> Thanks
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
"smithers2002" wrote:
> My formula calculation appears in the cell rather than the result/value- why
> is this happening, and how can I stop this?
>
> Thanks
On Thu, 6 Oct 2005 04:09:02 -0700, smithers2002
<[email protected]> wrote:
>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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks