Time and Date stamp

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

 

[Chip Pearson]

Ctrl+SHIFT+; will insert the time.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

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

 

[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

 

[pfsardella]

Sub InsertDateTimeStamp()
ActiveCell.Value = Now
End Sub

HTH
Paul
------------------------------------------------------------------------------

 

[MS]

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