It's as if the cell were formatted for text, but it is formatted for numbers

(or date). When I go through the formula function (rather than straight

entering), I can see in the formula function dialogue box the desired result

- just can't get it in the cell!

Does the sheet show the correct result when you press F9? If so, your

file is set for manual calculation. Go to Tools | Options |

Calculation (tab) and check Automatic. Save your file so that it will

be automatic when you next open it.

If not then the cell is probably pre-formatted to text. Changing the

format only comes into effect after the cell has been edited, so

double-click on that cell and then press <Enter>.

Hope this helps.

Pete

On Jul 25, 9:02 pm, Pat Adams < XXXX@XXXXX.COM >

file is set for manual calculation. Go to Tools | Options |

Calculation (tab) and check Automatic. Save your file so that it will

be automatic when you next open it.

If not then the cell is probably pre-formatted to text. Changing the

format only comes into effect after the cell has been edited, so

double-click on that cell and then press <Enter>.

Hope this helps.

Pete

On Jul 25, 9:02 pm, Pat Adams < XXXX@XXXXX.COM >

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

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

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

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

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

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

7. cells show formula like in formula bar, rather than result of form

8. Formula shown as a formula rather than it's result

9. Formula that returns formula won't show result...

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

11. Can't see formula result - only see formula - Excel 2002(OfficeXP)

12. How do I view formula results intead of formula in excel?

14. VBA Formula Result Different Than Manual Formula Result

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

2 post • Page:**1** of **1**