Problem: Formula displayed instead of value
Posted by Kristine on October 25, 2001 1:19 AM
I have a large worksheet where the original is protected. The copy works fine except for a few cells that display the formula instead of the value.
When I open the formuolawindow I can see that the result is correct, but it doesn't appear in the cell.
No formatting changes this. Anyone who can help!!!?
Posted by Barry Ward on October 25, 2001 2:48 AM
I thinks it's just a matter of going into tools - options and unchecking the formulas box there........
Posted by Kristine on October 25, 2001 2:59 AM
The box is unchecked
Posted by Don C on October 25, 2001 4:25 AM
I have found that entering a formula into a cell that had once contained a text item will sometimes display the formula, not the result, no matter what I do. Formats, check boxes, whatever, nothing will change the display to the result.
Copying the formula to another cell brings the problem to that new cell.
What I have had to do is retype the formula in a "new" cell and then move that cell into the location of the problem.
It's one of those little things that someday I'd like to understand what is going on, but retyping gets me around the problem so I just do that and move on.
Posted by Mark W. on October 25, 2001 6:14 AM
I'm betting that these cells are formatted as "Text"...
...reformat them as "General", click on the
formula bar, and press [ Enter ].
Posted by Mark W. on October 25, 2001 6:18 AM
The formulas option would apply to the entire worksheet... not just a few cells (nt)
