Hello all



Maybe this is a noob question but here I go. I'm a software developer and ironically this is like my third time ever using MS Excel. I'm using 2007 version.

The question is as follow:

I downloaded data from a software that show me the time and date which some images here in my job are processed. Here's is a screenshot of the data:



As you can see there, I have a column named "StartedTime" and the other one next to that one is named "FinishedTime". I have one of them showing me the time while the other is showing me the date. I can format this cell for them to show the time or the date. Is there ANY way to format them in order to see both, the time AND the date in the same space? If I put my cursor in a single row of one of the colum, it show me both, the time AND the date as you can see in the following example:



How I can format this columns so by default, all of it's rows show me BOTH the time, AND the date??? Thank you in advance!!!