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

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" <macshimi@discussions.microsoft.com> wrote in message
news:C8EA40BD-7DD2-42A7-B40B-959207E11BC3@microsoft.com...
> 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

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

I had checked the format and set it to General. I have got around the problem
by a simple IF statement. Very strange as it only those two columns, the rest
are problem free.

"Kernow Girl" wrote:

> 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