I have a listbox on a userform that returns a multicolom list of results including a date. The date is formatted on the worksheet as yyyy.mm.dd when the date is entered from a calender control it enters properly. My problem is when the search is done, the date is returned in the listbox as d/m/yy. Is there a way of formatting the date in the listbox to display as yyyy.mm.dd.

thanks