This might be something you have already thought of, bu tht ething that keeps
catch me out is forgetting to put the "=" in front of the formula - that
stays as text. Otherwise check the settings under tools-Options-View-Window
options - "Formulas" should not be checked.

Victoria

"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