"Epinn" wrote:
I am not talking about reversing right after. I am thinking of
entering a bunch of formulas somewhere else
and then coming back to this cell manipulated with F9, then reverse it.

CTRL+Z = Undo. At the cost of undo-ing several actions (several CTRL+Zs),
you might be able to get back to the particular F9+enter.

Also, after I press F9+enter, then save the worksheet, close it, reopen it and click on the formula (with value created by F9), how do I reverse it?

Once you click save, it's not possible to undo.

Do hang around for other possible insights
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---