keep date format in a Combo box

[Guest]

I have a list of dates that can be selected in a combo box. When I select a
date it reverts to the numeric value. Is there a way to keep the MM/DD/YYYY
format?

 

[Guest]

Hi,

I'm afraid the only 2 solutions I've come across are not perfect.

Solution 1 is to convert your list of dates into text by e.g. adding a
trailing space. You will probably then need to convert the chosen date back
into a proper date to use though.

Solution 2 is to use a combo box from the forms toolbar rather than the one
from the controls toolbar.

Unfortunately, both options may mean you have to rework your spreadsheet to
work with them.

Hope this helps,

Mark