Word converts English date to USA date in mail-merge from Excel?

D

DaveCujoPI

I'm using Microsoft office 2003.

In Excel, I have a column of dates which are formatted as UK ones (e.g. 2nd
July: 02/07/2007) but when this column is mail-merged into Word it's coming
out with the month first (e.g. 07/02/2007).

Even more bizarre, a second Excel column, which is a date from an IF
function, is going into Word the right way round - even though it has exactly
the same formatting as the first one.

Please help!
 
D

DaveCujoPI

Oh, I can see other people having the same problem now... I couldn't get to
this page without posting a question... ignore :)
 

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

Merging from an Excel file with graphics 1
Integrating information from Word to Excel (not mail merge) 1
Grouping Names in Mail Merge 0
Date format alters when merged into Word Document 0
Date format alters when merged into word document. 3
Date changes format after being merged from Data Source to Documen 0
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
excel - word - outlook -2007 mail merge problem 0

Top