View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
macshimi
 
Posts: n/a
Default Displaying Formula Results in Cell

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