Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Problem when date field from Excel database is inserted to Word 20
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Problem when date field from Excel database is inserted to Wor
Thanks Graham
when i did a further search i fould your and others previous posts, aoplogies for not looking further first but the way i got to the discussion group list didn't lend itself to a search that returned the answers. i found it interesting that this switch is not mentioned in the manuals for word or in the online help. Graeme |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Problem when date field from Excel database is inserted to Wor
Date formatting switches are certainly mentioned in Word Help.
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Gadgetgw wrote: Thanks Graham when i did a further search i fould your and others previous posts, aoplogies for not looking further first but the way i got to the discussion group list didn't lend itself to a search that returned the answers. i found it interesting that this switch is not mentioned in the manuals for word or in the online help. Graeme |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Problem when date field from Excel database is inserted to Wor
Graham
I agree they are they in general terms but no inference that they apply to mergefields, the only thing mentioned is 'case' Graeme - "Graham Mayor" wrote: Date formatting switches are certainly mentioned in Word Help. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Gadgetgw wrote: Thanks Graham when i did a further search i fould your and others previous posts, aoplogies for not looking further first but the way i got to the discussion group list didn't lend itself to a search that returned the answers. i found it interesting that this switch is not mentioned in the manuals for word or in the online help. Graeme |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
database field - merge single field from excel list | Microsoft Word Help | |||
Database field in Word to lookup a cell in an excel workbook | Mailmerge | |||
Problem in uploading database from excel | Microsoft Word Help | |||
Insert Field - Database - Wrong Date Format | Mailmerge | |||
Date issue merging from Excel field in Date format to Word | Mailmerge |