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

K

Keys1970

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
 
S

Sloth

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

PCLIVE

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
 
T

T Kirtley

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
 
K

Keys1970

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top