Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I fix invisible text in the formula bar? | Excel Discussion (Misc queries) | |||
Format cells to make zeros not appear,or be invisible on screen &p | Excel Discussion (Misc queries) | |||
Selected cells shadding Invisible. | Excel Worksheet Functions | |||
Invisible cells in VBA | Excel Programming | |||
Validation List with Variable Lengths & Invisible Empty Cells | Excel Programming |