View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
excelent excelent is offline
external usenet poster
 
Posts: 695
Default 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 ?