basic...but driving me crazy!
 

if I double click on a cell containing a formula the formula appears...and
won't go away!...the number attained from the fromula is replaced in the cell
with the formula...how do I get the product of the formula back and get rid
of the formula?...thank you...tino

hawsoon,

Sounds like you formatted your cells for Text after you initially entered
the formula: editing the formula then makes Excel treat the formula as text
and not a formula.

Select all your cells where this is a problem, and format them for general.
Then select each of the cells that are showing the formulas still,
double-click,a nd press enter. That will convert the text into a formula.

Note that even if the formula returns text, you do not format the cell as
Text - Text formatting forces Excel to treat everything entered as text,
including formulas.

HTH,
Bernie
MS Excel MVP


"hawsoon13" wrote in message
...
if I double click on a cell containing a formula the formula appears...and
won't go away!...the number attained from the fromula is replaced in the
cell
with the formula...how do I get the product of the formula back and get
rid
of the formula?...thank you...tino

if you hit enter does it go back?
also if there is a red X next to your formula bar, hitting that should get
you back to where you were.


"hawsoon13" wrote:

if I double click on a cell containing a formula the formula appears...and
won't go away!...the number attained from the fromula is replaced in the cell
with the formula...how do I get the product of the formula back and get rid
of the formula?...thank you...tino

"hawsoon13" ha scritto nel messaggio


if I double click on a cell containing a formula the formula
appears...and won't go away!...the number attained from the fromula
is replaced in the cell with the formula...how do I get the product
of the formula back and get rid of the formula?...thank you...tino


menu Tools, Option, Tab Edit and uncheck the checkbox Edit directly in cell.

--
Hoping to be helpful...

Regards

Franz

----------------------------------------------------------------------------------------
To reply translate from italian InVento (no capital letters)
----------------------------------------------------------------------------------------