View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default Changing date format from US to UK

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/cindy...r/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

"Pete" wrote in message
news
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