View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nick Hodge Nick Hodge is offline
external usenet poster
 
Posts: 1,173
Default ComboBox - Excel

Sarah

Format it. The number is simply how Excel stores dates (days are whole
numbers since 1/1/1900, times are decimals of a day)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS



sarah wrote:
Hi,

i have a problem when i choose a date in the combobox; for example, my
list contains some dates (08/05/2003 etc) and when i choose a
date,this is the number 37839 that appears.
How can I do to make visible the date and not the number?
Thanks,

Sarah