Windows Forum

Ask something
Discussion Locked

Merged Date Field in word in American

0 helpful
4 replies

by bjjhome.bt

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi All

Hope someone out there has the answer to this problem

I have an Excel Spreadsheet which is merging with Word (Both office 2003). When I merge the fields the dates convert to American Format

i.e. 23rd Nov 2005 as 11/23/2005

I have checked the settings in Windows and they are English UK
I have formatted the cells in Excell to dd/mm/yyy. But the dates still keep coming throug as American.

Please help as the hair is getting very thin!!!

Brian

4 replies

by gary56789

Quit Word?Start?Control Panel?Regional And Language Options?Customize button?Date tab?type in the Short date format and Long date format boxes the desired format?OK?OK?restart the merge.

Any problem, let us know.

This discussion is closed to new replies.