Hi Charles - it may be the Cell Format got set to Text. Execel is very
helpful and sets the format to what it thinks you entered, but it does get
mixed up sometimes. Check the cell and see if it says =+B8. If not then it is
has assumed you entered Text rather than an expression and set the Cell
format to Text. If it has the =, still make sure the Cell format is set to
General or somesuch, not Text. If no =, still check the format, delete and
enter again. Hope this helps

"macshimi" wrote:

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