Your cell was formatted as TEXT before entering the formula.
Format as General and re-enter the formula (F2, ENTER)

--
Kind regards,

Niek Otten

"Copper via OfficeKB.com" <u18830@uwe wrote in message
news:5c46b754d1e9a@uwe...
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