| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a drop down box with the date in it
using office 2003 excel
what i am trying to do is do a drop down box one with a date and one with time tried using the validation tool but it just gives me some weird number for both date and time. meaning i would like a drop down having nov 9 2007 - nov 12 2007 and i can select what date in the drop down. same with time but the whole 24 hours. is this possible ? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create a drop down box with the date in it
if it is datavalidating - did u format dropdowncell as date
and the other as time ? "Dustin" skrev: using office 2003 excel what i am trying to do is do a drop down box one with a date and one with time tried using the validation tool but it just gives me some weird number for both date and time. meaning i would like a drop down having nov 9 2007 - nov 12 2007 and i can select what date in the drop down. same with time but the whole 24 hours. is this possible ? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create a drop down box with the date in it
now that you mention it i did try that and it worked thank you soo much for
the help "excelent" wrote: if it is datavalidating - did u format dropdowncell as date and the other as time ? "Dustin" skrev: using office 2003 excel what i am trying to do is do a drop down box one with a date and one with time tried using the validation tool but it just gives me some weird number for both date and time. meaning i would like a drop down having nov 9 2007 - nov 12 2007 and i can select what date in the drop down. same with time but the whole 24 hours. is this possible ? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create a drop down box with the date in it
welcome
"Dustin" skrev: now that you mention it i did try that and it worked thank you soo much for the help "excelent" wrote: if it is datavalidating - did u format dropdowncell as date and the other as time ? "Dustin" skrev: using office 2003 excel what i am trying to do is do a drop down box one with a date and one with time tried using the validation tool but it just gives me some weird number for both date and time. meaning i would like a drop down having nov 9 2007 - nov 12 2007 and i can select what date in the drop down. same with time but the whole 24 hours. is this possible ? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create a drop down box with the date in it
Enter first date in a cell.
Copy down a few cells. Use that list as your DV dropdown list Format the DV dropdown cell as Date For the Time DV dropdown, I don't understand what range of times you want. A whole day's worth in minutes would be a 1440 item list. Enter any date in a cell. In cell below enter =cellref+1/1440 Drag/copy down to row 1440 Gord Dibben MS Excel MVP On Mon, 12 Nov 2007 08:38:01 -0800, Dustin <Dustin @discussions.microsoft.com wrote: using office 2003 excel what i am trying to do is do a drop down box one with a date and one with time tried using the validation tool but it just gives me some weird number for both date and time. meaning i would like a drop down having nov 9 2007 - nov 12 2007 and i can select what date in the drop down. same with time but the whole 24 hours. is this possible ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| Create new drop down from previous drop down selection | Excel Discussion (Misc queries) | |||
| how to create a combo box in excel - how to create the drop down . | Excel Discussion (Misc queries) | |||
| Can I create a drop-down list that will reference other drop-down | Excel Worksheet Functions | |||
| Create a drop down in XL cell to select date | Excel Worksheet Functions | |||
Linear Mode
