Sorry this is brief, quite busy at the moment.Try setting the custom format of the cell to:yyyymmdd:hhmm