cant calculate sum function

[Neeraj Paul]

when i try to calculate the sum function on my worksheet it returns the
whole function in text like for eg: =sum(A1:A5) returns the same text
=sum(A1:A5) and it does not calculate the figures.

thanks in advance

 

[Jacob Skaria]

You need re-enter the formula after chaning the format. or just F2 and enter..

If this post helps click Yes

 

[Neeraj Paul]

You need re-enter the formula after chaning the format. or just F2 and enter..

If this post helps click Yes

 

[Ragdyer]

Might you be in "Formula View"?

From the Menu Bar,
<Tools> <Options> <View> tab,
Under Window Options,
make sure that "Formulas" is *unchecked*.

Keyboard shortcut to toggle this:
<Ctrl> < ` >
with " ` " being the key (on my keyboard) under the <Esc> key, and above the
<Tab> key, with the " ~ " on the same key.

 

[Sheeloo]

or press CTRL-` once

Might you be in "Formula View"?

From the Menu Bar,
<Tools> <Options> <View> tab,
Under Window Options,
make sure that "Formulas" is *unchecked*.

Keyboard shortcut to toggle this:
<Ctrl> < ` >
with " ` " being the key (on my keyboard) under the <Esc> key, and above the
<Tab> key, with the " ~ " on the same key.

 

[Ragdyer]

I thought I said that.<g>

 

[Sheeloo]

Yes, you did it and I missed that. Sorry.

 

[Ragdyer]

I can't remember how many times I've failed to scroll down and read the rest
of the post.<bg>