Thread: Now function
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Albie Albie is offline
external usenet poster
 
Posts: 13
Default Now function

Awsome, I was hoping there was something simple like that.

"Teethless mama" wrote:

=NOW() (press F9 instead of ENTER)


"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?