What do you get? The formula itself like =mid(etc)?
If so the cell is probably formatted as text, format as general and if
necessary
edit the cell with F2 and the press enter
If you have a lot of these, one way that usually works is to do an edit>replace
and replace = with = (replace equal sign with equal sign) that usually
triggers
what's needed and it is much faster than pressing F2 and enter in all cells
separately
Peo
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.