ListBox date format

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

Can you post the code you used, or preferably, a .zip copy of the workbook?

Here is the code for the listbox results:

Please Login or Register  to view this content.