Date issue 31/07/15 14:57 in my sheet but 1931/07/15 2:10:37 PM in the "code line" ?

Hello,

First post here

I am really having trouble formatting my date correctly. The issue is that 31/07/15 14:57 in my sheet (is correct) but i get 1931/07/15 2:10:37 PM in the "code line" ? cannot really use my data with this "wrong" data how do i fix this ?

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

I believe you just need to match the column formatting for each column. In the source and target.
select the column > right click > format column > custom > and type in dd/mm/yy hh:mm Then press OK. Do the same for the target column.