When I export my log to Excel the dates come out in different formats. For example here are the first 6 log entries. They were all in July 2000. Notice that in the first 2 entries the format is MM/DD/YYYY and in the last 4 the format is DD/MM/YY
<COLGROUP>
<COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145" width=86>
07/01/2000
07/08/2000
18/07/2000
23/07/2000
29/07/2000
31/07/2000
This is replicated throughout the log with the date formats flip flopping. Strange thing is that they all display correctly inside Logbook Pro. Any idea how to correct this?
Jim
<COLGROUP>
<COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145" width=86>
07/01/2000
07/08/2000
18/07/2000
23/07/2000
29/07/2000
31/07/2000
This is replicated throughout the log with the date formats flip flopping. Strange thing is that they all display correctly inside Logbook Pro. Any idea how to correct this?
Jim