Changing date format from US to UK

[Pete]

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

 

[Doug Robbins - Word MVP]

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


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