Albie;

You could set up the worksheet to calculate manually. This would preclude
any updates until you choose. Unfortunately it will update when you
calculate. You could also try parsing. Choose =a1 and set to text. Try
parsing that cell.

God Bless

Frank Pytel

http://groups.google.com/group/excel...et-programming

"Albie" wrote:

I would like to use the now function to record the current system time with
seconds, but I do not want this function to update when I type another
instance of the now function. I need seconds so using ctrl+shift+; does not
work. Is there a short cut or syntax that I can use to keep the now function
static?