View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
stewart stewart is offline
external usenet poster
 
Posts: 44
Default date reverts to serial number

I have a drop down box in a userform that allows the user to select
from the seven days of the week. These days are stored on a sheet in
this format: dddd - mm/dd/yyyy and appear as such when the user clicks
on the drop down arrow. However once the desired day is selected it
shows the serial version of the date. Any suggestions on a way to set
it show that after the user selects the date it still shows the date
and not the serial