Mailmerge date problem

  • Thread starter Thread starter Jim Florence
  • Start date Start date
J

Jim Florence

I have written a mail merge routine which works fine apart from one
thing. The date on the word document that is created always comes out in
American format i.e. mm/dd/yy instead of dd/mm/yy.

The excel spreadsheet created has the correct date extracted from the
database and the language on the box and applications is all UK.

I'm very confused, any pointers gratefully received

Regards

Jim
 
Jim,

I've run into a situation much like this at work with the software program
that I support. Is the format for the Word field set to UK?
 
Hi Jim,

I am not too sure if this will help, but have you checked your regional
settings on the PC? I know this can cause a lot of problems.

Regards
Dave
 

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

Preserving date format 1
date format 1
Date Format 2
Finding Date in an overseas format 20
Vba Date$ 1
Fromat Date Wrong value for month 2
Date Format Problem. 2
Change date format in Excel footer 2

Back
Top