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
Bookmarks