Thread: Control Displays Number Instead of Date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chaplain Doug Chaplain Doug is offline
external usenet poster
  
Posts: 127
Default Control Displays Number Instead of Date
Excel 2003. I put a combobox control on my sheet that has a ListFillRange
that points to a column with dates in it. However, when I select one of the
dates, the combobox displays a number (e.g., 2/28/2006 is displayed as
38748). How can I set the format for the combobox so that it displays the
date properly? Thanks for the help.
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org
Reply With QuoteReply With Quote