Thread: combobox format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Terry V Terry V is offline
external usenet poster
 
Posts: 34
Default combobox format

Hello
I have a combo box that displays "times" of the day.
After clicking the dropdown, the times show up as they should (in the format
I put them into the cells with).
However, after making the selection from the box, the time is displayed as
"the number it represents". How can I format the display in the combobox,
after the selection is made, to reflect the same format the numbers have
been placed into the cells with? --- hh:mm AM

Thank you
Terry