basic...but driving me crazy!

H

hawsoon13

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
 
B

Bernie Deitrick

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
 
B

bj

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.
 
F

Franz

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
Click to expand...


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

--
Hoping to be helpful...

Regards

Franz
 
Top