Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to diaplay compare merge dialog box | Excel Programming | |||
Formula to write a value into a different cell. | Excel Programming | |||
write a formula to a cell using VBA | Excel Programming | |||
How can I write an if-then formula for 0 or less than 0 in cell t. | Excel Worksheet Functions | |||
Question: Cell formula or macro to write result of one cell to another cell | Excel Programming |