Cannot Calculate the Formula

E

Ellis Yu

Dear All,
I encountered a strange problem in Excel97. After I
input the formula in a cell, it doesn't calculate the
result and it still display the formula like a text in the
cell. But it happened on few cells only. I tried many ways
to figure out the problem like re-install the excel or
install the latest patch on it. Even I copied from another
cell which can calculate the formula normally, It still
display the formula in the cell. I also check the format
of the cell and it's general format. I have really no clue
on this. Therefore, I need to do my work again in a new
worksheet. It's really annoying to me. Would anyone help
me. Thanks

Ellis
 
F

Frank Kabel

Hi
your cell is probably formated as 'Text'. try the following:
- select the cell
- goto 'Format - Cells' and change the format to 'General'
- re-enter your formula
 
E

Ellis Yu

Hi Frank,
Thank for yr reply. I'd checked the format too, but the
format has been in 'General' type. So I'm thinking is
there any other setting or option may cause the cell
displaying the formula instead of calculating the result.
Do u know that?

Ellis
 
F

Frank Kabel

Hi
does that happen to all formulas in this sheet. If not you may email me
your file (getting curious...).
email: frank[dot]kabel[at]freenet[dot]de
 
R

Ron Rosenfeld

hank for yr reply. I'd checked the format too, but the
format has been in 'General' type. So I'm thinking is
there any other setting or option may cause the cell
displaying the formula instead of calculating the result.
Do u know that?
Click to expand...

Even if the format is GENERAL, if the formula happens to be preceded by a
<space> or any character other than the <equal> (=) sign, it will be
interpreted as TEXT.

Check this with =ISTEXT(A1).


--ron
 
E

Ellis Yu

Hi Ron,
I also suspected there's typing mistake at first, like
a space before "=" sign in the formula. So I try to copy
from another cell in which the formula can be calculated
the result. It still doesn't work. :(

Ellis
 
E

Ellis Yu

Hi,
No, it just happened on few cells only. Thus, I tried
to copy from other "normal" cell which contains formula,
but it still display the formula instead of result. I
think I can't send the file to you since it store in my
boss's computer. That file store some sensitive
information inside. I can open the file in her computer
only. (I really want someone else can find out the problem
for me, I also want to know what cause the problem)

Ellis

-----Original Message-----
Hi
does that happen to all formulas in this sheet. If not you may email me
your file (getting curious...).
email: frank[dot]kabel[at]freenet[dot]de

--
Regards
Frank Kabel
Frankfurt, Germany

Hi Frank,
Thank for yr reply. I'd checked the format too, but the
format has been in 'General' type. So I'm thinking is
there any other setting or option may cause the cell
displaying the formula instead of calculating the result.
Do u know that?

Ellis
in
the
Click to expand...

.
Click to expand...
 
F

Frank Kabel

Hi
if this happens only to a few cells in your workheets it has to be a
formatting issue :)
Check the following:
- what format is currently used?
- use the format painter to copy the format of a 'good' formula cell
and after thie re-enter the formula (or copy a different formula from
somethere)

--
Regards
Frank Kabel
Frankfurt, Germany

Ellis Yu said:
Hi,
No, it just happened on few cells only. Thus, I tried
to copy from other "normal" cell which contains formula,
but it still display the formula instead of result. I
think I can't send the file to you since it store in my
boss's computer. That file store some sensitive
information inside. I can open the file in her computer
only. (I really want someone else can find out the problem
for me, I also want to know what cause the problem)

Ellis

-----Original Message-----
Hi
does that happen to all formulas in this sheet. If not you may email me
your file (getting curious...).
email: frank[dot]kabel[at]freenet[dot]de

--
Regards
Frank Kabel
Frankfurt, Germany

Hi Frank,
Thank for yr reply. I'd checked the format too, but the
format has been in 'General' type. So I'm thinking is
there any other setting or option may cause the cell
displaying the formula instead of calculating the result.
Do u know that?

Ellis

-----Original Message-----
Hi
your cell is probably formated as 'Text'. try the
following:
- select the cell
- goto 'Format - Cells' and change the format to 'General'
- re-enter your formula

--
Regards
Frank Kabel
Frankfurt, Germany

Newsbeitrag
Dear All,
I encountered a strange problem in Excel97. After I
input the formula in a cell, it doesn't calculate the
result and it still display the formula like a text in
the
cell. But it happened on few cells only. I tried many
ways
to figure out the problem like re-install the excel or
install the latest patch on it. Even I copied from
another
cell which can calculate the formula normally, It still
display the formula in the cell. I also check the format
of the cell and it's general format. I have really no
clue
on this. Therefore, I need to do my work again in a new
worksheet. It's really annoying to me. Would anyone help
me. Thanks

Ellis

.
Click to expand...

.
Click to expand...
Click to expand...
 
R

Ron Rosenfeld

I also suspected there's typing mistake at first, like
a space before "=" sign in the formula. So I try to copy
from another cell in which the formula can be calculated
the result. It still doesn't work. :(
Click to expand...


And what was the result of the ISTEXT function on the cell that doesn't work?


--ron
 
R

Ron Rosenfeld

I also suspected there's typing mistake at first, like
a space before "=" sign in the formula. So I try to copy
from another cell in which the formula can be calculated
the result. It still doesn't work. :(
Click to expand...

In addition to the ISTEXT function, also do a LEN function and post a copy of
the actual formula.


--ron
 
Top