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

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.

(General or other) and then re-edit the formula. A quick way is to go to the

formula and hit F2 and then enter.

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

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

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

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

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.

Thanks for the responses. The formatting solution didn't work either.

Also, the problem doesn't occur on all the tabs, just a few.

1. Excel 2002 formula displayed not value formula option not checked

2. How to view a hidden/protected formula in Excel /showing a formula

3. My formula will not show the result, only the formula.

4. Cell shows formula and not the result of the formula.

5. Cell doesn't show formula result - it shows formula (CTRL + ' doe.

6. Wanted to show formula result, not formula. How???

7. I want the results of a formula to show in cell, NOT THE FORMULA!

8. i edit a formula (excel) then it displays formula not answer

9. Excel displaying formulae as constant and not calculating formula

10. Formula to show the content of a formula

11. EXCEL ANSWER TO FORMULA DOES NOT SHOW UP

12. formula to show + or - before the result of an existing formula

13. Excel show value not formula

14. Show Formula / Hide Formula

15. Show value of cell in formula bar instead of formula

5 post • Page:**1** of **1**