Hi, Thanks for the reply.
Below is a sample file extracted from PLC while the internal clock set to the following dates:
12/11/2013
5/11/2013
25/11/2013
25/12/2013
11/12/2013
11/2/2013
1/2/2013
10/2/2013
22/2/2013
22/5/2013
4/5/2013
as I have already mentioned I can see the same dates when I see the logged data in Ab Datalog Utility, however, when I save it, the date changes for some of them as follows:
Date Time Data1 Data2
11/12/2013 12:15:54 -250 -250
11/12/2013 12:16:04 -250 -250
11/05/2013 12:17:30 -250 -250
11/05/2013 12:17:34 -250 -250
11/05/2013 12:17:36 -250 -250
25/11/2013 12:17:54 -250 -250
25/11/2013 12:17:58 -250 -250
25/11/2013 12:18:00 -250 -250
25/12/2013 12:18:14 -250 -250
25/12/2013 12:18:18 -250 -250
25/12/2013 12:18:20 -250 -250
12/11/2013 12:19:06 -250 -250
12/11/2013 12:19:10 -250 -250
12/11/2013 12:19:12 -250 -250
2/11/2013 12:19:14 -250 -250
2/01/2013 12:19:16 -250 -250
2/01/2013 12:19:20 -250 -250
2/01/2013 12:19:22 -250 -250
2/01/2013 12:19:26 -250 -250
2/01/2013 12:19:28 -250 -250
2/10/2013 12:19:32 -250 -250
2/10/2013 12:19:34 -250 -250
22/02/2013 12:20:02 -250 -250
22/02/2013 12:20:06 -250 -250
5/04/2013 12:20:46 -250 -250
5/04/2013 12:20:50 -250 -250
11/12/2013 12:21:06 -250 -250
11/12/2013 12:21:08 -250 -250
I feel that it is AB Datalog Utility which is changing the date format, not the Excel.
Unfortunately, there is no option to save the data in CSV format.
Cheers,
Hamid