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