Invisible Formula in Cells !!!!!!!!!!!!!!!!!!
 

I have this strang excel file. When I enter formular into it, it don't show
thae value but when I enter anything else in the cell, that is visible. The
formula is in the cell, its just not visible.

Invisible Formula in Cells !!!!!!!!!!!!!!!!!!
 

On Apr 21, 7:41*am, Ayo wrote:
I have this strang excel file. When I enter formular into it, it don't show
thae value but when I enter anything else in the cell, that is visible. The
formula is in the cell, its just not visible.

Probably the sheet is protected and Hidden check box of Protection tab
of Format Cell dialog is checked.

Invisible Formula in Cells !!!!!!!!!!!!!!!!!!
 

That was the first thing I checked. Sheet is not protected and Hidden box is
not checked.

"Javed" wrote:

On Apr 21, 7:41 am, Ayo wrote:
I have this strang excel file. When I enter formular into it, it don't show
thae value but when I enter anything else in the cell, that is visible. The
formula is in the cell, its just not visible.

Probably the sheet is protected and Hidden check box of Protection tab
of Format Cell dialog is checked.
.

Invisible Formula in Cells !!!!!!!!!!!!!!!!!!
 

On 21 apr., 18:19, Ayo wrote:
That was the first thing I checked. Sheet is not protected and Hidden box is

The formula contain IF function ?

Invisible Formula in Cells !!!!!!!!!!!!!!!!!!
 

Show us the formula you entered.

Is it visible in the formula bar?


Gord Dibben MS Excel MVP

On Wed, 21 Apr 2010 08:19:01 -0700, Ayo
wrote:

That was the first thing I checked. Sheet is not protected and Hidden box is
not checked.

"Javed" wrote:

On Apr 21, 7:41 am, Ayo wrote:
I have this strang excel file. When I enter formular into it, it don't show
thae value but when I enter anything else in the cell, that is visible. The
formula is in the cell, its just not visible.

Probably the sheet is protected and Hidden check box of Protection tab
of Format Cell dialog is checked.
.