Windows 10 changed date format on Excel

//Windows 10 changed date format on Excel

Windows 10 changed date format on Excel

Don't forget to share

Windows 10 changed date format on ExcelHaving recently installed Windows 10 on my main PC I hadn’t had many problems.  Until I went to use some previously created Microsoft EXCEL documents. It was then I noticed that Windows 10 had completely changed the date format on Excel from English UK to American US date format.

So instead of showing dd/mm/yyyy it shows the US version mm/dd/yyyy on all of my Excel Documents.

Thankfully there is an easy solution – which is to install the “English (United Kingdom)” language pack.

It sounds crazy that we have to do that – but it saves having to alter the cells on all of our documents and its quick and easy to do.

Windows 10 changed date format on Excel

Don’t Panic

Its easy to change all of your documents back to UK date format on Excel

First go to Control Panel in Windows 10

Set the view to small icons so that you can see the folders

  • Click – Language
  • You will see English US highlighted
  • Click – English UK
  • Download and Install
  • Click – Yes
  • Go back to the Control Panel click MOVE UP on the UK version
    Windows 10 changed date format on Excel

Restart Excel and


You will also now notice that the time clock is back to 24hrs and beside the time – are the language preferences and you now have English UK

Your UK date formats are back!

See I told you there was no need to panic when Windows 10 changed date format on Excel !

By |2017-02-08T01:18:28+01:00September 30th, 2015|Categories: Tips and Tricks|0 Comments

About the Author:

Lover of Social Media/Networking, Digital comms, technology, computing, blogging, gadgets, music, and art. Modifying a written novel.

My Travel Map

This Is A Custom Widget

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.