Register Login

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

Views: 782 Replies: 9
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.
Asked: 22:33 29/03/2016
tomsk 22:33 29/03/2016
simoncuz 22:33 29/03/2016
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?
simoncuz 22:33 29/03/2016
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.
darkstuff1 22:33 29/03/2016
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
desquite 22:33 29/03/2016
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.
webby007 22:33 29/03/2016
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'.
topnet 22:33 29/03/2016
Turn date format back to British usage
skylo 22:33 29/03/2016
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.
georgew 22:33 29/03/2016
how do i get my english date format back. This windows 10 is no good, Give me my windows 7 back

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

Similar questions

I've reverted back to Windows 7 from Windows 10, and lost my sound in the process. How can I get the sound back?

windows 10 didnt suit me so i reverted back to 7 Lost the sound in tyhe process ...

How to change the date format in windows 10 mobile.

So I have a lumia 550 and live in the U S but I use the d m y format over the m d y Could anybody tell me how to change this without having to change ...

Windows 10 has disappeared from my laptop! How can I get it back?

I recently updated to Windows 10 & have some small problems But this morning when I logged on windows 10 appears to have disappeared completely! ...

My Windows 10 is going into sleep mode and I can't get it to wake up. How can I remedy this problem?

After a short time my computer goes into sleep mode and when I move my mouse around or click on the screen I can't get it to wake up The screen is ...

The paste button and control V does not work in word (after updating to Windows 10). How can I get it working?

The paste button and control V does not work in word (after updating to windows 10) It works in Excel and Explorer but not word Help needed!!!! ...

My lumia 920 screen has blacked out. How can i unlock it to get the data on my laptop?

I have tried soft reset I can hear the apps getting updated after the reset but unable to unlock it to read the data via my laptop ...

Update on Windows 10 has lost my accounts from Windows 7, how can I get them back?

our account ; with yahoo mail in windows 7 has been lost ! I've had important emails returning to this account ; we need this account back asp! ...

Windows 10 map showing wrong location, how can I get it to show the correct location?

it says I am a few miles away from where i am really at ...

How do I change my settings to take off NARRATION so I can use my phone in the original format? ASAP

I accidentally put my phone on NARRATION and cannot access ANYTHING on my phone Please HELP ASAP ...

how can i up date my microsoft money 2000 to work with windows 10

after updating my windows 10 my Microsoft money 2000 no longer come up ...