Date format changes when exporting to a csv file
barbarabeach
Member
I am trying to make an excel table of transactions from my Mac Quicken for Canada investment account.
The date format is unusable in numbers or excel so the table won't sort by date. the date format in my quicken is 10-07-2020. WOW! It just changed!
In my register it appears to be 2020-mm-dd. In .csv format it switches to m/d/yyyy and I cannot get excel to recognize the number as a date.
The date format is unusable in numbers or excel so the table won't sort by date. the date format in my quicken is 10-07-2020. WOW! It just changed!
In my register it appears to be 2020-mm-dd. In .csv format it switches to m/d/yyyy and I cannot get excel to recognize the number as a date.
Tagged:
0
This discussion has been closed.