TIME STAMP inserted with f5 key ?

[mike k]

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]

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

 

[Peo Sjoblom]

Ctrl + :

 

[Guest]

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

 

[Peo Sjoblom]

Ctrl ; + space + Ctrl :

or use a macro

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