How do I automatically enter a time and date?
Either of two methods for automatic entry.
1. Double-click on a cell to enter time and date.
2. Enter data in one cell and date and time appear in another cell.
Manually...........Hold CTRL + ; then <space then CTRL + SHIFT + ; then ENTER
Post back for event code for 1 or 2
2 is easist........no clicking.
Gord Dibben MS Excel MVP
On Fri, 28 Sep 2007 11:31:02 -0700, Wayne
wrote:
I am trying to track calls that my sales staff makes on leads that I supply
them. Can anyone tell me how to set a column that automatically inserts a
date and time by just clicking on it? For example:
Name Of Borrower Lead Source Date and Time Called Result Notes
|