View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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.
.