Excel Formula Doesn't Execute (Shows formula-not the calcuation)

Excel Formula Doesn't Execute (Shows formula-not the calcuation)

Post by S2V5czE5Nz » Thu, 16 Nov 2006 00:40:03


I am encountering a situation where I create a simple Excel forumla, for
example, =sum(A1:A3). I create the formula by 1) typing it in OR 2) type
equal sign and go select another cell on another tab OR 3) copy/paste from
another formula (that is working). Case 3 seems to work, but then I have to
edit the formula to get the exact cell reference address. The results of
cases 1 and 2 are: the formula is shown (not the calculation).

I have reviewed Tools\Options. I have Automatic Calculation selected and
Windows Options Formulas box is not checked. I claim to have installed all
suggested MS Office updates. Any ideas? Thanks.

Troy
 
 
 

Excel Formula Doesn't Execute (Shows formula-not the calcuation)

Post by U2xvdG » Thu, 16 Nov 2006 00:44:02

the cells are probably formatted as text. Change the format to a number
(General or other) and then re-edit the formula. A quick way is to go to the
formula and hit F2 and then enter.

 
 
 

Excel Formula Doesn't Execute (Shows formula-not the calcuation)

Post by PCLIV » Thu, 16 Nov 2006 00:48:58

Additionally,

If you have a lot of formulas in your workbook that you'll need to edit, you
can do a Find and Replace. Find = and Replace with =.

Regards,
Paul
 
 
 

Excel Formula Doesn't Execute (Shows formula-not the calcuation)

Post by VCBLaXJ0bG » Thu, 16 Nov 2006 00:50:02

It sounds like the cell is formatted as text so Excel ignores the formula.

In the Format/Cells/Number option box change the cell's format to a non-text
format such as 'General', then edit the cell by pressing F2 and press enter.
That should do it.

HTH,

TK
 
 
 

Excel Formula Doesn't Execute (Shows formula-not the calcuation)

Post by S2V5czE5Nz » Thu, 16 Nov 2006 23:12:01

All,

Thanks for the responses. The formatting solution didn't work either.
Also, the problem doesn't occur on all the tabs, just a few.