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 ?
--
Rich
http://www.richdavies.com/fantasy-football.htm


** Posted from http://www.teranews.com **

"Rich" wrote in message
...
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 ?
--
Rich
http://www.richdavies.com/fantasy-football.htm


** Posted from http://www.teranews.com **


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.....

--
Rich
http://www.richdavies.com/fantasy-football.htm


** Posted from http://www.teranews.com **

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

"Rich" wrote in message
...
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 ?
--
Rich
http://www.richdavies.com/fantasy-football.htm


** Posted from http://www.teranews.com **