How to insist to show results for all formulas?

Hi,

I have a lot's of formulas on spreadsheat. Some of them simple like (=R[-101]C), others more complex like(="LOC_" & VALUE(MID(R[-101]C[-8],5,6)) + 101).
Some of cells show result while others show formulas instead. When I press F9 while editing for formulas which doesn't display result it shows correct result - so, formulas are correct.
Somehow I insisted for some columns to show results but could not reproduce it for others.

How to insist to show results for all formulas?

I use Excel 2007.

Thanks,
Sergiy

If you "re-enter" formulae the cells will coerce from Text to General and results will be displayed... a few ways to do this:

1 - highlight cells affected and run Edit -> Replace: What: = With: =
2 - highlight cells affected one column at a time and run Text to Column -> click Finish
3 - format cells to General - edit formulae individually and press return (ie F2 -> Enter)

Option 1 likely to be your best bet...