Excel ignore formula

[johannes]

When I write a formula in a cell, e.g. =SUM(A2:A10), Excel 2007 treat
threat as a literal text string, and no formula action occurs?
i.e. the cell just displays the content "=SUM(A2:A10)"

 

[h2so4]

johannes wrote :

When I write a formula in a cell, e.g. =SUM(A2:A10), Excel 2007 treat threat
as a literal text string, and no formula action occurs?
i.e. the cell just displays the content "=SUM(A2:A10)"

the option show formula is probably activated

to change

goto office button (top left)
click excel options (bottom right)
select advanced in the menu on the right
locate display option for this worksheet

uncheck - show formulas instead of their calculated value

 

[johannes]

johannes wrote :

the option show formula is probably activated

to change

goto office button (top left)
click excel options (bottom right)
select advanced in the menu on the right
locate display option for this worksheet

uncheck - show formulas instead of their calculated value

Thanks very much, but the cell you mentioned was already unchecked.
The phenomenon seems to happen randomly; if I copy a formula which
is already working and change the range in the formula, then it
displays like a text string, whereas the original formala (the source
for the copy) still calculates.

 

[h2so4]

johannes has brought this to us :

On 25/05/2013 11:18, h2so4 wrote:

Thanks very much, but the cell you mentioned was already unchecked.
The phenomenon seems to happen randomly; if I copy a formula which
is already working and change the range in the formula, then it
displays like a text string, whereas the original formala (the source
for the copy) still calculates.

try to retype the = sign. (remove and reinsert)

 

[GS]

When I write a formula in a cell, e.g. =SUM(A2:A10), Excel 2007 treat

threat as a literal text string, and no formula action occurs?
i.e. the cell just displays the content "=SUM(A2:A10)"

Change cell format to 'General'!!!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[johannes]

johannes has brought this to us :


try to retype the = sign. (remove and reinsert)

None of this worked. I think it is a compatibility problem with the
imported Excel file, not knowing which Excel version it came from.
When copying and paste the cell range into a fresh blank worksheet,
it all works as expected.

 

[johannes]

Change cell format to 'General'!!!

Yes, thanks that worked. Format was switched to Text (by someone...)

 

[PeCoNe]

Op 2013-05-25 12:00, johannes schreef:

When I write a formula in a cell, e.g. =SUM(A2:A10), Excel 2007 treat
threat as a literal text string, and no formula action occurs?
i.e. the cell just displays the content "=SUM(A2:A10)"

Is it a language problem =SOM <> =SUM?

Bye Peter Maljers

 

[johannes]

Op 2013-05-25 12:00, johannes schreef:
Is it a language problem =SOM <> =SUM?

Bye Peter Maljers

Nah, the importet s/s had cell format set to Text as default. That was
the reason.

What language is SOM anyway? If I write SOM(..), and the cell format
is set correctly, it will respondd by #NAME?