Date?

K

kevs

In the commands, there is not something I can put on toolbar, which would
insert today's date in a cell?
 
J

JE McGimpsey

kevs said:
In the commands, there is not something I can put on toolbar, which would
insert today's date in a cell?
Click to expand...

No, though you can use the keyboard shortcut CTRL-;

You could also add a toolbar button and attach this macro:

Public Sub EnterDate()
With ActiveCell
.NumberFormat = "dd mmm yyyy"
.Value = Date
End With
End Sub
 
B

Bob Greenblatt

In the commands, there is not something I can put on toolbar, which would
insert today's date in a cell?
Click to expand...
Why not just type control-semi colon? (Apple-semi colon will insert the
time).
 

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

Space at end of multi page list to accommodate new entries 1
Incorporating the User Profile location into a document template path 1
Display weeks from a Milestone 0
Conditional Formatting question.... 1
Word hyperlinks not working 2
Autofill Date in Word 15.33 for Mac 0
How do I post date a letter? 1
Excel 2016 odd behavior 1

Top