Saturday, July 24, 2010

MS Word 2010 and the UK date format

Why oh why do Microsoft make things more and more obscure with each iteration of their Office products? Today I had to battle with a new issue. After creating a letter using one of the default templates, I selected the date from a drop-down box only to find that it was in the US format (mm/dd/yyyy) with no apparent way of changing it to the UK format (dd/mm/yyyy).

US date format

After much searching in the less-than-helpful help files, and doing some googling, I came across a solution that somebody had posted for MS Word 2007.

This was helpful, but I found in Word 2010 I was missing something vital that they had described - a "Developer" tab! So, I found how to enable this and thought I would share the knowledge...

First you need to click on the File tab, then select Options from the Help sub-menu. Once in the options screen, select Customize Ribbon from the options on the left. Under the Main Tabs on the right, you should see that Developer is unchecked. Check the box and click OK.

image

Now select the Developer tab and click on the date in order to select it. In the Controls section of the “ribbon” you should see a button labelled Properties.

image

Click this while you have the date selected and you should be presented with the following window where you can adjust the date format to match what you expect to see here in the UK. To do this, change the “Locale” from “English (U.S.)” to “English (U.K.)”

image

I hope this saves somebody from the searching that I had to do in order to solve what should be a very simple problem.

16 comments:

David Bridge said...

Thanks for this. I doubt I would have found it without your post.

Why do the Americans rule the world when theu come up with all these "my way or the highway" ideas. Dates are a basic fundamental part of a document and should be easy to format.

I hope many more benefit from your excellently written article.

David Bridge
David Bridge Technology Limited
www.davidbridgetechnology.com

Big T said...

Thanks mate. It was driving me insane.

DebS said...

Thanks so much for this.

It was driving me mad. It's just this sort of obscurity that turns me away from Microsoft, and for years I've avoided using Word.

Now I find I have to use it for work, but that date issue had me tearing my hair out. I'm really grateful for your work here.

Deb

Unknown said...

Very helpful - thanks.

Goldenleaf said...

Thanks :) Silly Microsoft making our lives more difficult...

Susy2cat said...

Thank you so much for this. I was going mad trying to change the date!

Incredible that we have to hunt around for this.

HelenaT said...

Thank you. That was a really clear and helpful set of instructions.

Anonymous said...
This comment has been removed by the author.
Anonymous said...

Spot on - thanks so much for posting this. I was also run ragged trying to find a way to change it!

masterix275 said...

Thank you! I would have never figured this out on my own!

Unknown said...

Well that saved me hours of frustration. Well done!!

lab said...

you're a life saver!! thanks so much for this!

SharePoint Girl said...

Had this problem for the first time today! Thank you so much!

Unknown said...

Thanks - helped me out greatly. Dave T

KS said...

Very helpful! Thank you soooo much!

FozzyFoster said...

THANK YOU :-)