formula does not calculate

T

TaiwanSwede

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!
 
S

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
 
S

Stefi

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


„TaiwanSwede†ezt írta:
 
V

VBA Noob

Also check your options. Auto Calc maybe switch off

Tools > Options > Calcualtion Tab then click Auto Calc

VBA Noob
 
M

Max

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.
 
M

Muhammed Rafeek M

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