Need to change date/time format on 2 columns of data

How do I format the date and time shown in the columns boxed in red to display like the one boxed in green? (Refer to pics)   I want both columns to look like e.g 24/11/2009  9:32:00 PM not 2009.11...