odd behavior

R

Rich

Hi,

I have a problem with a particular workbook I'm building. If I try to amend
a formala, instead of the result, the formalu is visible in the cell, and no
calculation takes place. As an example, if I put "=a1" into cell b1, it
displays "=a1" instead of the value of a1.

All the formats seem OK, and this appears usually after I amend a previous
formula. I've never seen it before. No macros in the workbook either.


Any ideas ?
 
R

Rich

Rich said:
Hi,

I have a problem with a particular workbook I'm building. If I try to
amend a formala, instead of the result, the formalu is visible in the
cell, and no calculation takes place. As an example, if I put "=a1" into
cell b1, it displays "=a1" instead of the value of a1.

All the formats seem OK, and this appears usually after I amend a previous
formula. I've never seen it before. No macros in the workbook either.


Any ideas ?
Click to expand...


Disregard, Donna's post has just appeared on my server, and the response.

I was using "SUBSTITUTE" in my formula to remove the space from the postcode
field, by replacing " " with "". I guess this also changed the format of the
cell to text without me realising.....
 
D

David Biddulph

You've probably got the cell formatted as Text. Format the cell as General,
then re-enter the formula.
 
Top