Time and Date stamp

  • Thread starter Thread starter MS
  • Start date Start date
M

MS

I keep a large mailing list in Excel and often add new
records. Is there a method to add a date and time stamp to
each record at the time of entry? I know that using (ctrl
+ ;) will add the date but I would like to add the time as
well. Thanks for any help.
 
Thanks Chip. That was helpful. I am hoping to make it a
bit easier and thought I could use your info to create a
macro by using "Ctrl+;" "space" "Ctrl+SHIFT+;". That did
not work for me as I only got the time and date that the
macro was recorded. Any suggestions?
 
If you are using a macro, then you don't want to use the shortcuts you were
given. Those are worksheet shortcuts. Just use a line like:
[A1]=Now
Format the cell for date and time. HTH Otto
 
Sub InsertDateTimeStamp()
ActiveCell.Value = Now
End Sub

HTH
Paul
------------------------------------------------------------------------------
 
Back
Top