How do I force Word to use UK date format

M

marcothepirate

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.
 
M

marcothepirate

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

Get the right language when inserting a date 2
How do I change the US date format to UK date format? 1
How to extract email addresses from a word document 2
Mail Merge with Excel - Date not Formatting Correctly 2
Word 2016: How do I change a REF field code that references a Heading style to Arabic when the Headi 1
Change US date to UK date in mail merge 1
Force MS Word to use UK Dictionary 5
how do I display the date a document was created, not modified 0

Top