Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
text plus date and time
I have a list of names and I want to put those names in a drop down list.
Once someone selects a name from the drop down list I want that name and the current date and time to populate that cell. Does anyone have any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
text plus date and time
I think you'll be much happier if you use a different cell for the date/time.
It'll make life much, much easier later. If you want to try that... J.E. McGimpsey shows how at: http://www.mcgimpsey.com/excel/timestamp.html Kelly wrote: I have a list of names and I want to put those names in a drop down list. Once someone selects a name from the drop down list I want that name and the current date and time to populate that cell. Does anyone have any suggestions? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
text plus date and time
This may be a simple approach, but here goes...
Lets say in cell A2 is your drop list. Format cell B2 for Time, and cell C2 for Date and insert the following formulas. in cell B2 insert: =IF(A2="","",NOW()) in cell C2 insert: =IF(A2="","",TODAY()) "Kelly" wrote: I have a list of names and I want to put those names in a drop down list. Once someone selects a name from the drop down list I want that name and the current date and time to populate that cell. Does anyone have any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting text in cell to a date time | Excel Worksheet Functions | |||
Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
How to convert DATE and TIME to text | Excel Worksheet Functions | |||
Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions |