CSV cell display not same as edit cell

I'm in receipt of a multi rows date and time csv file exported from non Excel software:-

The cell displays as 17/01/2014 20:53

Yet the edit cell displays as 17/01/2014 20:53:41

I tried formatting the cells to dd/mm/yyyy hh:mm.00 but that returns all the seconds to .00 and I have tried many Google suggestions but none have worked.

How do I get the cell to display all the information?

Many thanks Ron it worked great.

Ruth