Displaying Formula Results in Cell
Are those cells formatted as text. Change them to General, then F2 to edit,
and Enter.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"macshimi" wrote in message
...
I have a very strange problem, in certain cells, the formula displays and
not
the result. No, I do not have 'display formula' turned as other cells are
operating correctly.
Here is a very simple example, I am copying the cell data above and the
first two cells show the formula and the next the result. If I replace
'+B8'
with, say, =Proper(B8), I still only see the formula.
703611B NH054837A Radford T Aug-65 Jan-89
703611B NH054837A Radford T Aug-65 Apr-94
+B8 +C8 Radford T 23981 34429
Any help greatly appreciated.
Charles
|