A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do I change the US date setting in the event schedule planner



 
 
Thread Tools Display Modes
  #1  
Old April 26th, 2010, 02:10 PM posted to microsoft.public.word.docmanagement
At work
external usenet poster
 
Posts: 1
Default How do I change the US date setting in the event schedule planner

Help! I'm using a lovely little template called event schedule planner -
however it shows the date in US date format and I need the UK format
(dd.mm.yyyy) how do I change it in this template please?
  #2  
Old April 26th, 2010, 03:13 PM posted to microsoft.public.word.docmanagement
Graham Mayor
external usenet poster
 
Posts: 18,297
Default How do I change the US date setting in the event schedule planner

If this is Word 2007/2010 then the chances are that it uses date content
controls to display the dates. You can change them all with a macro

Sub Macro1()
Dim oCC As ContentControl
For Each oCC In ActiveDocument.ContentControls
If oCC.Type = wdContentControlDate Then
oCC.DateDisplayLocale = wdEnglishUK
oCC.DateDisplayFormat = "dd.MM.yyyy"
End If
Next oCC
End Sub


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"At work" At wrote in message
...
Help! I'm using a lovely little template called event schedule planner -
however it shows the date in US date format and I need the UK format
(dd.mm.yyyy) how do I change it in this template please?



  #3  
Old April 26th, 2010, 04:14 PM posted to microsoft.public.word.docmanagement
Pamelia Caswell via OfficeKB.com
external usenet poster
 
Posts: 44
Default How do I change the US date setting in the event schedule planner

I can help you change one and then copy it, though there ought to be a way to
do it all at once for the same type of control.

Open the template. Select an empty content control that you want to edit.
Turn on the Developer mode (It's on the developer tab. If you don't see it,
go to Word options and put a check mark in the the box before "Show Developer
tab in ribbon". ) Then click Properties. Change the locale from English
(US) to English (UK). Then set your preference for how the date will display.
OK out of the content control properties dialog.

Copy the edited control to the clipboard. Select the other, like content
controls and paste. Make sure you are out of the developer mode. Check to
make sure the developer mode is off. Save the template.

Pam





At work wrote:
Help! I'm using a lovely little template called event schedule planner -
however it shows the date in US date format and I need the UK format
(dd.mm.yyyy) how do I change it in this template please?


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...ement/201004/1

  #4  
Old April 26th, 2010, 04:21 PM posted to microsoft.public.word.docmanagement
Pamelia Caswell via OfficeKB.com
external usenet poster
 
Posts: 44
Default How do I change the US date setting in the event schedule planner

Below, I should have written *Design mode*.

Graham's macro is way cool, but knowing how to do it yourself is also cool.

Pam
Pamelia Caswell wrote:
I can help you change one and then copy it, though there ought to be a way to
do it all at once for the same type of control.

Open the template. Select an empty content control that you want to edit.
Turn on the *Design mode* (It's on the developer tab. If you don't see it,
go to Word options and put a check mark in the the box before "Show Developer
tab in ribbon". ) Then click Properties. Change the locale from English
(US) to English (UK). Then set your preference for how the date will display.
OK out of the content control properties dialog.

Copy the edited control to the clipboard. Select the other, like content
controls and paste. Make sure you are out of the developer mode. Check to
make sure the developer mode is off. Save the template.

Pam

Help! I'm using a lovely little template called event schedule planner -
however it shows the date in US date format and I need the UK format
(dd.mm.yyyy) how do I change it in this template please?


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...ement/201004/1

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:41 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.