AB DataLog Utility

Hi,
I was wondering if any of you had any issue with the date when you exporting the data to Excel. When I upload the data to AB Data Log Utility the date is fine.
However, when I save and open them in Excel, the day and month for some of the dates have been replaced.
Any suggestion is welcome.
Cheers,
Hamid

You mean in the american format?
I remember having to do a custom date to text format or something like that. It was to long ago last time I used the utility.
Can you paste the csv file.
It should be easy to do...

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

Looks your stuck with what you have got.
You will have to correct it in excel.
I would be happy to have a play if you could post both files (I have the utility hiding somewhere) or put them on drop box.