View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Problem when date field from Excel database is inserted to Word 20

Assuming Windows Regional settings are correct - see
http://www.gmayor.com/formatting_word_fields.htm
and http://homepage.swissonline.ch/cindy...2.htm#DatesBug

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Gadgetgw wrote:
I have a table with names date, invoice numbers etc in Excel 2007. I
am using this for a mail merge in Word. Everthing inserts ok except
date fields which are displaying in excel in Australian (dd/mm/yyyy
or dd-MMMM-yyyy) format are always converted to US mm/dd/yyyy format.

I have converted the files to Word and Excel 2003 format and tried on
a differnt computer running Office 2003 and i get the same result.