| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula does not calculate
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula does not calculate
I find that if my cells are formatted as 'text' the formulas dont work. Are your cells formatted as text ? if so try changing to general.......and then re type the formula -- Steel Monkey ------------------------------------------------------------------------ Steel Monkey's Profile: http://www.excelforum.com/member.php...o&userid=29051 View this thread: http://www.excelforum.com/showthread...hreadid=562739 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula does not calculate
Check cell format! It is probably set to Text. Set it to General!
Regards, Stefi €˛TaiwanSwede€¯ ezt Ć*rta: 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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula does not calculate
Also check your options. Auto Calc maybe switch off Tools Options Calcualtion Tab then click Auto Calc VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=562740 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula does not calculate
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. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula does not calculate
Select entire column and go Data--Text to Column, then just click finish.
your problem will solve. "TaiwanSwede" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| any formula to auto calculate 1st-12th is 12 days pls? | Excel Discussion (Misc queries) | |||
| Need formula to calculate days between dates or back date | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
| Formula to calculate over-time | Excel Discussion (Misc queries) | |||
Linear Mode
