On Wed, 31 May 2006 19:50:12 +1200 yuri <[EMAIL PROTECTED]> wrote: > Use =now(), then copy it and paste it back using one of the paste > options to paste the value only rather than the formula (I think it's > under "paste special"). > > Yuri > (sorry for the top post - I'm in a hurray)
thanks, too involved, too long. Someone emailed me offlist as they were not using their subscribed account use =now() and before you hit <enter> use <F9> Now to see about writing a macro. A key shortcut would be the most efficient!
