Hi

Format cell(s) in desired time format.


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)



"Terry V" wrote in message
...
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