formula does not calculate

[Guest]

Help!

Something is weird with my Excel sheet. When I enter a formula, for example
=AB2+AB3
Excel does not calculate the result. Instead the formula just stays as it
is. I am sure there is some strange option that has been chosen by accident,
but I can't come up with where.

Any help out there!

 

[Steel Monkey]

I find that if my cells are formatted as 'text' the formulas dont work
Are your cells formatted as text ? if so try changing t
general.......and then re type the formul

 

[Guest]

Check cell format! It is probably set to Text. Set it to General!
Regards,
Stefi


„TaiwanSwede†ezt írta:

 

[VBA Noob]

Also check your options. Auto Calc maybe switch off

Tools > Options > Calcualtion Tab then click Auto Calc

VBA Noob

 

[Guest]

Check cell format! It is probably set to Text. Set it to General!

Just a little add-on to Stefi's note above (and as hinted in Steel Monkey's
response) ... The formula needs to be re-confirmed* before it'll work after
re-formatting to General (or Number). *Eg: click inside the formula bar,
press ENTER. The re-formatting alone will not fire the formula.

---

 

[Guest]

Select entire column and go Data-->Text to Column, then just click finish.
your problem will solve.