basic...but driving me crazy!

[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

[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


"hawsoon13" <hawsoon13@discussions.microsoft.com> wrote in message
news:A63DF2A1-38F7-4F1B-AEE8-362148D86F61@microsoft.com...
> 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

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


"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

[Franz]

"hawsoon13" <hawsoon13@discussions.microsoft.com>ha scritto nel messaggio
A63DF2A1-38F7-4F1B-AEE8-362148D86F61@microsoft.com

> 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)
----------------------------------------------------------------------------------------