I have a workshhet combobox that the listfillrange is on another sheet -
sheet2!a13:50 which contains a list of dates formated as dd/mm/yy

After selecting a date from the drop down list the link cell and the
combobox displays the date serial number.

How do I get both the link cell and the combobox to always display the
selected date in dd/mm/yy format.


thanks in advance


--
mudraker
------------------------------------------------------------------------
mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473
View this thread: http://www.excelforum.com/showthread...hreadid=531732