Did you actually start the formula with an equal sign:

=right(g3,2)

If you did, try formatting the cell as General. Then select the cell, hit F2
and then Enter (to tell excel you want the formula re-evaluated).



"Copper via OfficeKB.com" wrote:

I have entered a RIGHT function, when i go to Insert, Function command and do
RIGHT(G3,2), calculation shows up correctly in function box, but does not
calculate in cell itself. Still displays command RIGHT(G3,2)
What am I doing incorrectly? Have checked Tools, Options, Calculation, and
Automatic is checked. Thanks in advance for your co-operation.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200602/1

--

Dave Peterson