I am using a list box with different times in it and have
linked it to a cell. I have formatted the cell for a
certain time format, say h.mm AM/PM, but all I get in the
cell is what the sample says (12:00 AM) in the dialog box
where you make your format selection.

If I change the formating to number or something else, I
get variation when I make different selections in the list
box, but of course this is not the format I want.

Can someone tell me, What is going on?