TIME STAMP inserted with f5 key ?

mike k · Oct 30, 2003

is there a way to get a time stamp
inserted in excel 2000 like in
notepad where you just press f5 ???

thanks

Michael J. Malinsky · Oct 30, 2003

Ctrl + Shft + : - inserts the time
Ctrl + ; = inserts date

Peo Sjoblom · Oct 30, 2003

Ctrl + :

Guest · Oct 30, 2003

great but how do you get
the DATE AND THE TIME ALL AT ONCE ???

Peo Sjoblom · Oct 30, 2003

Ctrl ; + space + Ctrl :

or use a macro

Sub EnterDate_Time()
ActiveCell.Value = Now
ActiveCell.NumberFormat = "mm/dd/yy hh:mm:ss"
End Sub