Dates in Excel are all mixed up and won't convert
Closed
stuey
TrowaD
- Posts
- 1
- Registration date
- Monday June 26, 2017
- Status
- Member
- Last seen
- June 26, 2017
TrowaD
- Posts
- 2888
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- August 16, 2022
Related:
- Dates in Excel are all mixed up and won't convert
- How to use if function with dates in excel - Guide
- How to format dates in excel - Guide
- Calculate Time Between 2 Dates in Excel - How-To - Excel
- Conditional formatting with dates: in Excel - Guide
- Update dates in Excel spreadsheet: each year, formula - Guide
1 reply
TrowaD
Jun 27, 2017 at 10:47 AM
- Posts
- 2888
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- August 16, 2022
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