Carol
If I read your question correctly, you want to go to a cell that has a
formula, and change that formula from a formula to merely a text of the
formula. Is that right?
If that's what you want to do, then select that cell, go into Edit mode
(press F2) and put an apostrophe ( ' ) as the first character in the cell.
Press Enter. There is the formula as text. Note that this "text formula"
will not function as a formula anymore. HTH Otto
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.
