Forum Discussion
Excel overrules Windows regional setting for two digit year translation
Default setting (1950-2049) in Windows 11 doesn't work from the box, we need first to "activate" it. Change on 1951-2050 or whatever you prefer. Apply. After that you may return back to 1950-2049 and apply again. It shall work now, 30 goes to 2030. Not necessary to restart Excel after the setting is applied.
If you want to type a date that is before January 1, 1930, or after December 31, 2029, you must type the full four-digit year. For example, to use the date July 4, 2076, type 7/4/2076.
Dates in the inclusive range from January 1, 1900 (1/1/1900) to December 31, 9999 (12/31/9999) are valid.
I don't know if this information will help you in any way, but I've included it as a notice. 🙂
I know I don't know anything (Socrates)
- Thank you but no, the information is not helpful. The issue was specified as Excel overruling the Windows setting, with the undesired result. Typing a 4-digit date is a work-around, not a solution.
The only thing I can suggest is to pre-convert the cells to text and use error checking to check for the century if necessary.
Or type an apostrophe (‘) before a number, example: '01.02.30.
The apostrophe does not appear in the cell after pressing Enter.
- Thanks, but as said: I'm NOT looking for a workaround.
My question was rather specific if there was any Windows option I overlooked that is making Excel ignore the Windows setting. Because according to MS's own information Excel should follow Windows on this.
And anyway: adding the apostrophe is as much of a hassle as typing a 4-digit date. And by rendering the input to text you can't use formulas calculating the no. of days between two dates. And this is exactly the reason why the century actually IS relevant in the first place.
So thanks, but unless you have an answer to my question: "Is there a Windows option I overlooked that is making Excel ignore the Windows setting (contrary to MS's own design)", pls ignore this thread.
