I have created a form with a combo box to select an answer. The particular box I'm having the problem with is one linked to cells that are formatted as a date (01-Jan-07).

The combo box is showing the correct cell data when you drop it down, but when you select the correct date, the box is showing the number for the cell that I've selected.

This is driving me crazy, how do i format it to show the date?

Jackie