Pulling my hair out!
Windows region settings are English UK with short and long dates as day month year.
The cell format is DD-MM-YY HH:MM:SS
If I click on the time at the bottom right of my desktop the calender that comes up shows 1 December.
So windows knows the correct date.
I am using Office 365 Excel version 2102 (Build 13801.21050 Click-to-Run) Semi-Annual Enterprise Channel
I enter a date using Ctrl-;
or DateTime using Ctrl-; [space] Ctrl-:
The date is being interpreted as 12 January rather than 1st December
Re-format cell to long date - the sample date shown says 12 January 2021.
If instead of using the shortcut to enter date I enter =Today() or =Now() or 1/12/2021 everything works as it should.
This is a newish issue. Any ideas? Is it a known bug?
Thanks in advance for any inspiration, pointers etc.
Gavin
Windows region settings are English UK with short and long dates as day month year.
The cell format is DD-MM-YY HH:MM:SS
If I click on the time at the bottom right of my desktop the calender that comes up shows 1 December.
So windows knows the correct date.
I am using Office 365 Excel version 2102 (Build 13801.21050 Click-to-Run) Semi-Annual Enterprise Channel
I enter a date using Ctrl-;
or DateTime using Ctrl-; [space] Ctrl-:
The date is being interpreted as 12 January rather than 1st December
Re-format cell to long date - the sample date shown says 12 January 2021.
If instead of using the shortcut to enter date I enter =Today() or =Now() or 1/12/2021 everything works as it should.
This is a newish issue. Any ideas? Is it a known bug?
Thanks in advance for any inspiration, pointers etc.
Gavin