Stop UK-style dates changing to US-style dates when mailmerging.

J

Jean XO

Using Office 2007. When I use Excel as the database and mailmerge in Word,
all my UK-style dates (eg 25/04/2003) change to US-style (eg 04/25/2003).
Does anyone know, please, what can I do to format the dates, either in Excel
or Word, to ensure they keep the UK format?
 
C

Castell

Go to Control Panel/Regional Settings and ensure that all items in each of
the 4 tabs are set correctly.

Also, highlight the cells in Excel that contain the dates that are causing
the problem, select Format/FormatCells/Date and ensure the Locale is correct
also.
 

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 can i change dates from US to UK format 1
Excel 2007 displayed dates 2
keeping dates in UK format 7
Date conversion on text file import 5
Recognising dates pre-1900 14
Dates ( UK Formats ) 3
Dates don't appear properly after downloading data from Accounting 4
How stop Excel file UK date order changing to US order in m.merge 1

Top