Calculation not working

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

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

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

Should be: =RIGHT(G3,2)
Note the equal sign.

George Gee


"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

Yes, had entered =, forgot to mention that. Somehow thought F9 was key to
hit, had done the General formatting but wrong Function key. Thanks a bunch,
cannot say enough about this site. Thanks as well for your response Niek
Otten.


Dave Peterson wrote:
>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).
>
>> 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