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