Change Date Format in Word 1

[Caspers]

I am mail merging data from Excel into a Word document. The date format in Excel is dd/mm/yyyy but when I merge into the Word document it is changing to mm/dd/yyyy. Anyone any ideas on keeping UK format in word document.

 

[xlhelp]

Please look at this thread, it may help:

thread68-399663

If not, please post again.

 

[Caspers]

Thanks for the tip, but this hasn't solved the problem. All entries in registry were set correctly. The date is showing correctly in Excel i.e. dd/mm/yyyy it is just when I merge with a word document that it changes to mm/dd/yyyy, any more suggestions.

 

[andream]

I had the same problem and found the answer here:

http://www.health.ufl.edu/itcenter/training/handouts/Word/Word-MailMerge2-Handout.pdf

The problem is that although the format looks ok in excel it actually stores it a certain way (I found this info somewhere else)and you need to tell word how to manipulate it back using the mergefield command when it comes in from excel.

 

[andream]

Go to

http://support.microsoft.com/default.aspx?scid=kb;en-us;320473

here's the real answer(the other one i gave only manipulated the incorrect date)its all in HOW you merge from excel

 

[Caspers]

Andream

Thanks very much for the tip, it has sorted the problem. You've saved me a lot of work.