Hi All,

I created a combo box that is linked to a set of cells that contain
numbers but for which I have selected to format as time i.e. the cells
look like this:

12:00 AM
12:30 AM
1:00 AM
1:30 AM
2:00 AM
2:30 AM

My problem is that when I select a value with the combo box, it
displays them as the number, not as a formatted time and I cannot see
which property to edit on the combo box to have the output formatted as
time.

Any help would be most appreciated!


Rob
:)