Another way is to format the cells as general then do editreplace and
replace = with =
that will trigger a calculation and convert the formulas


--


Regards,


Peo Sjoblom


"pinmaster" wrote in message
...
Hi,

If the cell was preformatted as text then yes the formula will appear
rather
than the result, you need to format the cells as General or other
depending
on the result you want, but just formatting the cell will not work you
need
to re-enter the formula by selecting the cell and hitting F2 then ENTER,
if
you have a whole column like this then a faster way is to select the
column
then go to DATA/Text to column, NEXT, NEXT and FINISH... this method only
works if you select consecutive cells in a column, will not work with
rows.

HTH
Jean-Guy

"Jerry Bennett" wrote:

I have this problem over and over, in 2003 and 2007; sometimes if i
change a
formula, the formula will appear then in the cell as text instead of the
value or string calculated by the cell, and i cannot get it to change,
unless
i copy the original formula from another cell in the same column. Or,
even
worse, sometimes whole columns will not accept formulas of any kind, they
will just display the formula in the cell as text. In that case i have
to
delete the whole column and insert a new one and then it is ok. What
gives?
Can i fix this? Thanks
--
Jerry