how can i display the date and time of a cell entry in excel?
 

i'm using excel to capture some data entry for a few users. i would like to
be able to automatically insert the date/time a user entered a value into
another cell in the same row as opposed to having the user select the date.
is this possible? if i use the 'today' function... i believe this will
change each time the worksheet is opened. Any ideas?

how can i display the date and time of a cell entry in excel?
 

Hi,

Just use a Time stamp ...
see John's excellent example :
http://www.mcgimpsey.com/excel/timestamp.html

HTH

how can i display the date and time of a cell entry in excel?
 

That would require VBA, if you are up for it post back with more details, and
someone will help

Vaya con Dios,
Chuck, CABGx3



"Alex76" wrote:

i'm using excel to capture some data entry for a few users. i would like to
be able to automatically insert the date/time a user entered a value into
another cell in the same row as opposed to having the user select the date.
is this possible? if i use the 'today' function... i believe this will
change each time the worksheet is opened. Any ideas?

how can i display the date and time of a cell entry in excel?
 

You could use an event macro like the one at J.E. McGimpsey's site:
http://www.mcgimpsey.com/excel/timestamp.html

Alex76 wrote:

i'm using excel to capture some data entry for a few users. i would like to
be able to automatically insert the date/time a user entered a value into
another cell in the same row as opposed to having the user select the date.
is this possible? if i use the 'today' function... i believe this will
change each time the worksheet is opened. Any ideas?

--

Dave Peterson