Excel ignore formula

  • Thread starter Thread starter johannes
  • Start date Start date
J

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)"
 
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)"
Click to expand...

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 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
Click to expand...
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.
 
johannes has brought this to us :
On 25/05/2013 11:18, h2so4 wrote:
Click to expand...
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.
Click to expand...

try to retype the = sign. (remove and reinsert)
 
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)"
Click to expand...

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 has brought this to us :


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

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.
 
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)"
Click to expand...
Is it a language problem =SOM <> =SUM?

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

Bye Peter Maljers
Click to expand...

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?
 
Back
Top