MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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