Exporting historical data

[staycool3_a]

20140102 130100;89.62;89.7;89.62;89.7;66
20140102 130900;90;90;90;90;270
20140102 131100;89.97;90;89.97;90;600
20140102 131200;90;90;90;90;500
20140102 132100;90.05;90.05;90.05;90.05;100
20140102 133700;89.94;89.94;89.94;89.94;500
20140102 134300;89.85;89.85;89.84;89.84;400
20140102 135500;89.81;89.81;89.8;89.8;500
20140102 135600;89.8;89.8;89.8;89.8;600

above is an example of historical data from NT for a stock.

I copy pasted in excel and delimted the columns using space and colon.

now my question is; how do i edit the time stamps to see the actual time? i tried hhmmss as custom cell format but it gives me 12AM for all of them. any idea? thanks

[NinjaTrader_PatrickH]

Hello calhawk01,

Thank you for your post.

I found an example under a Google search at the following link: http://www.extendoffice.com/document...dard-time.html