Displaying date and time format in Listbox

Hi,

The code bellow displays in my Listbox, 2 columns with the date and time from a variable range.

Please Login or Register  to view this content.

Everything code runs ok, the only thing is that the values displayed in my listbox does not have the correct format. The date appears as "mm/dd/yyy" and the time as a number instead of "hh:mm".

Does someone know how to display it properly?

Any help would be much appreciated. Thanks!

Kind regards,

Hi,

Problem solved! Was quite easy actually, only formatting the cell as "Text" where the information was stored.

Regards!!