Can you help on " No display in formaulbar i can written in cell?"
Example ::
I can write in A2 cell
=A1+1
"=A1+1" diaplay in formulabar but i want to solve this problem "=A1+1" No
display in formulabar.
Please kindly Solve this problem.

Cell formatting>Protection>Check "Hidden" box!

Regards,
Stefi

„Darshakâ€� ezt Ã*rta:

> Can you help on " No display in formaulbar i can written in cell?"
> Example ::
> I can write in A2 cell
> =A1+1
> "=A1+1" diaplay in formulabar but i want to solve this problem "=A1+1" No
> display in formulabar.
> Please kindly Solve this problem.

Is it possible the cell is formatted as text?
Delete the formula; format the cell General and re-type the formula, press
Enter to finish
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Darshak" <(E-Mail Removed)> wrote in message
news:CA050920-4170-4959-B3BE-(E-Mail Removed)...
> Can you help on " No display in formaulbar i can written in cell?"
> Example ::
> I can write in A2 cell
> =A1+1
> "=A1+1" diaplay in formulabar but i want to solve this problem "=A1+1" No
> display in formulabar.
> Please kindly Solve this problem.

Hi there,

Do like Stefi said but for this to work you need to protect the spreadsheet
--
Howard31


"Darshak" wrote:

> Can you help on " No display in formaulbar i can written in cell?"
> Example ::
> I can write in A2 cell
> =A1+1
> "=A1+1" diaplay in formulabar but i want to solve this problem "=A1+1" No
> display in formulabar.
> Please kindly Solve this problem.

Thanks Howard, I forgot it!
Stefi


„Howard31â€� ezt Ã*rta:

> Hi there,
>
> Do like Stefi said but for this to work you need to protect the spreadsheet
> --
> Howard31
>
>
> "Darshak" wrote:
>
> > Can you help on " No display in formaulbar i can written in cell?"
> > Example ::
> > I can write in A2 cell
> > =A1+1
> > "=A1+1" diaplay in formulabar but i want to solve this problem "=A1+1" No
> > display in formulabar.
> > Please kindly Solve this problem.