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