Windows 10 has turned my British date format in Excel into the American date format. How can I get it to turn back?

[Windows Central Question]

Windows 10 has turned my British date format in Excel into the American date format. How can I get it to turn back?

Since installing Windows 10 - previously on Windows 7 - all dates in Excel have turned into the American date format i.e. previously 12/08/15 in a cell displayed as 12th August 2015. Now it displays correctly but the cell contents have changed, so, in previous example, the cell now contains 08/12/15. How can I put this right? I have gone into anything I could see re language and have ensured it is English (United Kingdom) but this hasn't made any difference.

 

[tangledW]

Re: Windows 10 has turned my British date format in Excel into the American date format.

Freeeeeeeeeeeeedom!

 

[Mike Jojn Hall]

Re: Windows 10 has turned my British date format in Excel into the American date format.

I've got exactly the same problem and it's bloody annoying. Annoying enough in fact that my other PCs will not be upgrading until it is solved.

In fact the problem is more general: dates of emails in Live Mail and dates modified in whatever File Manager is now called have also switched to the mm/dd/yyyy format. This suggests some really crap testing by Microsoft.

Anyone got a solution?

 

[Mike Jojn Hall]

Re: Windows 10 has turned my British date format in Excel into the American date format.

To reply to myself since I realised that the general nature of the problem meant it must be due to an incorrect setting.

Got to Settings/Time & Language/Date & Time/Formats/Change Date and Time Formats and change the short and long date formats to ones starting with "d".

Microsoft should have got this setting right during conversion and should have given us more formats starting with "d", given that there are four short formats starting with "M". In fact, there should be UK versions of all these four USA formats, d/M/yy for example.

 

[JD_Palmer]

Re: Windows 10 has turned my British date format in Excel into the American date format.

The best (and complete) solution is to install the "English (United Kingdom)" language pack.

This can be found by going to: Control Panel [make sure you select 'view by: Small icons' in the top right so you can see all items] then select 'Language'. Here you will see the default "English (United States)" option with "enabled" against it and should see the "English (United Kingdom)" option below. [If not you should be able to find it via the 'add a language' button] Click on options and then the "Download and install language pack button"

Just wait for it to install then highlight the recently installed option and click the 'move up' button so that this becomes your default. It should display "Will be enabled on next sign-in". It will do exactly that, after a reset it will be enabled and should be your default.

This will then give you the wider variety of date options i.e. dd/MM/yy and d/M/yy that (as mentioned above) is not an option otherwise.

Hope this helps

 

[Ball Park]

Re: Windows 10 has turned my British date format in Excel into the American date format.

Windows 10 changed the wonderful custom format of excel in windows 7 mmm-yy to a useless device. Before feb 13 showed as Feb 13 and was a great help. Now feb 13 yields Feb 15. The custom formats are separate from the date formats so why must windows 10 assume yy can only mean 15? Windows 10 only accepts 15 for yy: mar 07 gives Mar 15 etc. How many million people need to have a reliable way to enter dates in columns of financial records? My guess is at least as many British who prefer to use British date conventions.

 

[Roving Press books]

Thank you very much for the fix - it was driving me crazy!
Took me a while to find the language download, as it was in 'Settings' rather than ' Control Panel'.

 

[GHRobinson]

Turn date format back to British usage

 

[Uttoxeter]

Thanks for the tip to make sure that the English ( United Kingdom) Language is set as default.
I was having major issues using our Sage Accounts software - it really got confused with the limited date format options.

 

[rossostu]

how do i get my english date format back. This windows 10 is no good, Give me my windows 7 back