i can write a formula in cell but it can diaplay in formualbar.
 

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.

i can write a formula in cell but it can diaplay in formualbar.
 

Cell formattingProtectionCheck "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.

i can write a formula in cell but it can diaplay in formualbar.
 

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" wrote in message
...
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.

i can write a formula in cell but it can diaplay in formualbar.
 

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.

i can write a formula in cell but it can diaplay in formualbar
 

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.