Formulas display as text string
Posted by Dan Trivett on February 21, 2001 4:21 PM
I am having trouble getting a formula to display the results. Instead the formula shows up in the cell, but it won't evaluate the results. If I enter it on the formula bar, it displays the result correctly in the formula box, but it still shows the formula as a text string in the cell. I've seen this before, but don't know why it occurs.
Posted by Faster on February 21, 2001 4:46 PM
The cell may have a text format. If it does change
it and then re-edit the cell.
Good luck
Posted by David Hawley on February 21, 2001 9:39 PM
You can re-edit each cell by using Edit>Replace: = with =
Dave
OzGrid Business Applications
