| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Freezing Date/Time after data entry. | New Users to Excel | |||
| Data Entry date/time? | Excel Discussion (Misc queries) | |||
| Automatically entering time and date to an entry | Excel Discussion (Misc queries) | |||
| if a cell contains text, then display date and time | Excel Discussion (Misc queries) | |||
| How do I set up Auotomatic date and time entry in an adjacent cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
