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).
 
Top