Prev: Search and Replace, or Add New Row
Next: Count previous 30 cells two sheets
From: Ayo on 20 Apr 2010 22:41
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.
From: Javed on 21 Apr 2010 01:36
On Apr 21, 7:41 am, Ayo <A...(a)discussions.microsoft.com> 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.
From: Ayo on 21 Apr 2010 11:19
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 <A...(a)discussions.microsoft.com> 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.
> .
>
From: ytayta555 on 21 Apr 2010 17:49
On 21 apr., 18:19, Ayo <A...(a)discussions.microsoft.com> wrote:
> That was the first thing I checked. Sheet is not protected and Hidden box is

The formula contain IF function ?
From: Gord Dibben on 21 Apr 2010 20:06
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 <Ayo(a)discussions.microsoft.com>
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 <A...(a)discussions.microsoft.com> 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.
>> .
>>

 | 
Pages: 1
Prev: Search and Replace, or Add New Row
Next: Count previous 30 cells two sheets