Loading Profile...
Exported date fields show wrong in Excel sheet
Exporting my data to Excel, all dates show wrong.
E.g. a certain bill has bill date 26-11-2008 (dd-mm-yyyy)
and due date 03-12-2008 (dd-mm-yyyy).
Then in the export excel sheet the bill date shows as 39778 and the due date as 39785.
Don't have a clue what kind of format this is...
E.g. a certain bill has bill date 26-11-2008 (dd-mm-yyyy)
and due date 03-12-2008 (dd-mm-yyyy).
Then in the export excel sheet the bill date shows as 39778 and the due date as 39785.
Don't have a clue what kind of format this is...
I’m a bit stressed, since I have an appointment with my accountant tomorrow...
1
person has this problem
I have this problem, too!
Tell me when someone solves it.
The more people who report this problem, the more it gets noticed.
The more people who report this problem, the more it gets noticed.
-
Inappropriate?Hmm,
may be forget about this one...
I tried to change the cell properties in Excel, set the number format to "date" (locale Dutch), and then it seems to be okay...
I'll do a double check and let you know if everything is allright.
I’m unsure...
-
Inappropriate?Well, the trick seems to work:
changing the number format of the cells to "date".
But the strange thing is, sometimes the export files seem to be right at once, and sometimes the export files are wrong - so that I need to do the format trick...
I’m confused...
-
Inappropriate?Today I did an export, and guess...
The date fields seem to be right at once ;)
I’m amused
-
Inappropriate?And today I did an export...
The date fields e.g. for expenses are:
39561
39582
39597
39617
39650
39687
39723
39736
...
Et cetera
I’m confused
