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

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)
 
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selecting Last Record 5
Auto Stamp Date 13
Date stamp user 7
how do I put a date/time stamp in comments? 2
Time Stamp 8
Date Stamp in Footer 1
time stamp question 2
Adobe Acrobat Stamp 0

Top