How do I force Word to use UK date format

G

Guest

I am trying to mail merge dates from Excel into a Word document, but they are
always displayed in US style. eg 4/9/2006 (4 Sept 2006) is converted to 9
April 2006 on merging. I have used the \@ "d MMMM yyyy" switch as given in
the Help items.
 
H

Herb Tyson [MVP]

In Windows' Control Panel, open Regional and Language Options. In the
Regional Options tab, set the format to English (United Kingdom). If
Word/Excel are already running, you'll need to close and restart them for it
to take effect.
 
G

Guest

Thanks for this suggestion but the UK settibngs are the default on my
machine, so I don't think the problem lies there. I assume that there must be
something about the way that the date is picked up from Excel that over-rides
the regional formats.
 
H

Herb Tyson [MVP]

How are the dates formatted in Excel? Format, Cells, Number tab, and look at
Locale.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I change the US date format to UK date format? 1
Mail Merge with Excel - Date not Formatting Correctly 2
Mail Merge date from txt data source 2
Force MS Word to use UK Dictionary 5
Microsoft Word 2007 Date Format and Header 1
Word 2003 Date format (UK) 3
How can I add a format to the "Insert Date" format gallery? 1
When merging date into Word 2003 from Excel, how do I keep the fo. 1

Top