Dates in Excel are all mixed up and won't convert
Closed
stuey
Posts
1
Registration date
Monday June 26, 2017
Status
Member
Last seen
June 26, 2017
-
Jun 26, 2017 at 07:14 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 27, 2017 at 10:47 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 27, 2017 at 10:47 AM
Related:
- Dates in Excel are all mixed up and won't convert
- Convert number to words in excel - Guide
- Convert m3u to mp3 - Guide
- How to convert number to words in word - Guide
- Convert picture to shape powerpoint - Guide
- Marksheet in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jun 27, 2017 at 10:47 AM
Jun 27, 2017 at 10:47 AM
Hi Stuey,
When I select all your dates and paste it in Excel, then the dates are automatically converted to a matching format.
This could be a Mac thing, which I have no experience with.
Something you can try is using a formula:
=TEXT(A1,"YYYY-MM-DD")
As for your other question, my quess would be localization. The default date format in my country (Netherlands) is dd-mm-jjjj.
Best regards,
Trowa
When I select all your dates and paste it in Excel, then the dates are automatically converted to a matching format.
This could be a Mac thing, which I have no experience with.
Something you can try is using a formula:
=TEXT(A1,"YYYY-MM-DD")
As for your other question, my quess would be localization. The default date format in my country (Netherlands) is dd-mm-jjjj.
Best regards,
Trowa