I don't think Excel can remember it. I assume once F9 is pressed, it treats it as if I actually key in the value.

Never mind. I am a big dreamer. May be it'll happen in 20_ _?

Epinn

"Epinn" wrote in message ...
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. 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?

Epinn

"Max" wrote in message ...
"Epinn" wrote:
.. is a shortcut key to reverse F9+enter.
How about CTRL+Z ?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---