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

[Ayo]

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.

 

[Javed]

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.

 

[Ayo]

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

 

[ytayta555]

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

The formula contain IF function ?

 

[Gord Dibben]

Show us the formula you entered.

Is it visible in the formula bar?


Gord Dibben MS Excel MVP