Problem when date field from Excel database is inserted to Word 20

G

Gadgetgw

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

Gadgetgw

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
 
G

Graham Mayor

Date formatting switches are certainly mentioned in Word Help.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
G

Gadgetgw

Graham

I agree they are they in general terms but no inference that they apply to
mergefields, the only thing mentioned is 'case'

Graeme -
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
Date Formats 4
Publisher is filling blank lines with data 2
Merged Date Field Converting from Australian layout to American 2
Mail merge date from Excel 2003 to Word 2003 in same format 4
Export Report with Graph to Excel error 2495 1
How to enter a date in DD-MM-YYYY format 2
Insert merge field not merging dates correctly. 1

Top