software

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.

703611BNH054837ARadford TAug-65Jan-89
703611BNH054837ARadford TAug-65Apr-94
B8 C8Radford T2398134429

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)

quot;macshimiquot; gt; wrote in message
...
gt; I have a very strange problem, in certain cells, the formula displays and
not
gt; the result. No, I do not have 'display formula' turned as other cells are
gt; operating correctly.
gt; Here is a very simple example, I am copying the cell data above and the
gt; first two cells show the formula and the next the result. If I replace
' B8'
gt; with, say, =Proper(B8), I still only see the formula.
gt;
gt; 703611B NH054837A Radford T Aug-65 Jan-89
gt; 703611B NH054837A Radford T Aug-65 Apr-94
gt; B8 C8 Radford T 23981 34429
gt;
gt; Any help greatly appreciated.
gt;
gt; 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

quot;macshimiquot; wrote:

gt; I have a very strange problem, in certain cells, the formula displays and not
gt; the result. No, I do not have 'display formula' turned as other cells are
gt; operating correctly.
gt; Here is a very simple example, I am copying the cell data above and the
gt; first two cells show the formula and the next the result. If I replace ' B8'
gt; with, say, =Proper(B8), I still only see the formula.
gt;
gt; 703611BNH054837ARadford TAug-65Jan-89
gt; 703611BNH054837ARadford TAug-65Apr-94
gt; B8 C8Radford T2398134429
gt;
gt; Any help greatly appreciated.
gt;
gt; 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.

quot;Kernow Girlquot; wrote:

gt; Hi Charles - it may be the Cell Format got set to Text. Execel is very
gt; helpful and sets the format to what it thinks you entered, but it does get
gt; mixed up sometimes. Check the cell and see if it says = B8. If not then it is
gt; has assumed you entered Text rather than an expression and set the Cell
gt; format to Text. If it has the =, still make sure the Cell format is set to
gt; General or somesuch, not Text. If no =, still check the format, delete and
gt; enter again. Hope this helps
gt;
gt; quot;macshimiquot; wrote:
gt;
gt; gt; I have a very strange problem, in certain cells, the formula displays and not
gt; gt; the result. No, I do not have 'display formula' turned as other cells are
gt; gt; operating correctly.
gt; gt; Here is a very simple example, I am copying the cell data above and the
gt; gt; first two cells show the formula and the next the result. If I replace ' B8'
gt; gt; with, say, =Proper(B8), I still only see the formula.
gt; gt;
gt; gt; 703611BNH054837ARadford TAug-65Jan-89
gt; gt; 703611BNH054837ARadford TAug-65Apr-94
gt; gt; B8 C8Radford T2398134429
gt; gt;
gt; gt; Any help greatly appreciated.
gt; gt;
gt; gt; Charles