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