A third possiblity.

OP literally did not preface the string with the "=" sign.


Gord

On Tue, 18 May 2010 11:27:01 -0700, Gary''s Student
wrote:

There are two possible reasons you would seee the formula in a cell rather
than the value;

1. The cell was formatted as Text. To fix this, re-format the cell to
General and re-endter the formula

2. The Formula Display mode is on. To fix this just touch CNTRL-`