Time and Date stamp

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.
 
G

Guest

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

Otto Moehrbach

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
 
P

pfsardella

Sub InsertDateTimeStamp()
ActiveCell.Value = Now
End Sub

HTH
Paul
------------------------------------------------------------------------------
 
M

MS

Thanks for the quick help. This will improve my
productivity quite a bit. Have a great day!
 
Top