Changing date format from US to UK

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pete - 09 Feb 2006 11:31 GMT

I am having a problem merging dates from a spreadsheet. The original dates on
the spreadsheet have been entered in the British format ie. dd/mm/yyyy
however when they are transferred to Word they show in the US format ie
mm/dd/yyyy. I have been unable to find an option in Word to change anything
other than grammar/spelling from US to UK. How can I make the dates on the
mail merge show in the same UK format as the spreadsheet?

Any ideas?
Thanks,
Peet

Reply to this Message

Doug Robbins - Word MVP - 09 Feb 2006 11:46 GMT

See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
Meister's website at
http://homepage.swissonline.ch/cindymeister/MergFram.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am having a problem merging dates from a spreadsheet. The original dates
>on
[quoted text clipped - 8 lines]
> Thanks,
> Peet

Reply to this Message