Date Problem when marging Excel date into Word

[Richard Territt]

Hello, i work in a college and i am having a problem when marging an excel
file into word, The
Date format is correct in excel spreashjeet to be merged. When it is merged
into Word document the dates appear in US format. Changed word language to
English UK but not resolved the problems.

Also the computers Regional & Language Settings are all set to uk,

 

[Richard Territt]

Sorry i forgot to say we are using Office 2003.

 

[DL]

This copied from an earlier post;
----------------------------------
This is because you are using the default OLE DB data connection and
it only passes the data from Excel to Word which does not include
formatting.

You'll need to add a Date-Time picture switch to the merge field in
Word:

- Press Alt + F9 to toggle the field codes
- At the end of your date field add: \@ dd/MM/yy
- Press Alt + F9 to toggle off the field codes

Note that the month format must be in uppercase. A lowercase 'm' is
for minutes.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/