need cell formulas to display results not the formula 
Author Message
 need cell formulas to display results not the formula

When I type a simple formula ,
e.g. =SHEET_NAME!A1
my worksheet sometimes returns the result, but other times
gets stuck on displaying the formula.

It's strange.
When I enter the formula for the first time, I get the
result.  The contents of the cell reference I want is
displayed. But once I re-enter the cell (using F2) to edit
the formula, I don't see anything but the formula!

I sent a sample worksheet with this strange behavior to a
friend in another city and he got the same strange
behavior.  So I don't think the problem is local to my
workstation.

Has anyone had similar problems?



Sat, 13 Aug 2005 19:25:33 GMT  
 need cell formulas to display results not the formula
On Tue, 25 Feb 2003 10:25:33 -0800, "Louise Zimmerman"

Quote:

>When I type a simple formula ,
>e.g. =SHEET_NAME!A1
>my worksheet sometimes returns the result, but other times
>gets stuck on displaying the formula.

>It's strange.
>When I enter the formula for the first time, I get the
>result.  The contents of the cell reference I want is
>displayed. But once I re-enter the cell (using F2) to edit
>the formula, I don't see anything but the formula!

>I sent a sample worksheet with this strange behavior to a
>friend in another city and he got the same strange
>behavior.  So I don't think the problem is local to my
>workstation.

>Has anyone had similar problems?

When you edit, you are likely doing something that turns the formula into
text.  Accidentally entering a leading space might do that, but there are
other ways.

You can check to see if what you think is a formula is really text, by
entering the formula  =ISTEXT(cell_ref) in a blank cell.  Substitute the
address of the misbehaving formula cell for cell_ref.

--ron



Sat, 13 Aug 2005 20:48:23 GMT  
 need cell formulas to display results not the formula
On Tue, 25 Feb 2003 10:25:33 -0800, "Louise Zimmerman"

Quote:

>When I type a simple formula ,
>e.g. =SHEET_NAME!A1
>my worksheet sometimes returns the result, but other times
>gets stuck on displaying the formula.

>It's strange.
>When I enter the formula for the first time, I get the
>result.  The contents of the cell reference I want is
>displayed. But once I re-enter the cell (using F2) to edit
>the formula, I don't see anything but the formula!

>I sent a sample worksheet with this strange behavior to a
>friend in another city and he got the same strange
>behavior.  So I don't think the problem is local to my
>workstation.

>Has anyone had similar problems?

Oh, my previous recommendation will not work if the result of your formula
is text, only it is numeric.  But if that doesn't work, post back.

--ron



Sat, 13 Aug 2005 20:49:45 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. formula in cell displays as the formula - not the result

2. Cell displays formula instead of formula result

3. Cell displays formula and not result

4. Cell displays formula and not results

5. Display and print formulas, not results in cells

6. VLookup: Cell displays actual formula and not result

7. Formula result not displayed in cell

8. Need to replace cell formula with cell formula

9. Displays formula instead of result of formula

10. Excel displays formula instead of result of formula


 
Powered by phpBB® Forum Software © phpBB Group