Merged date fields come out in wrong format

L

lori

I had this happen also. It drove me crazy, then I found
that you can add a switch to the end of your merged date
and format it the way you want it to appear. Go to where
you can see the codes and add at the end of your date
\@ "MM DD, YYYY" I think this is correct or you can go
to help and select "ate-Time Picture (\@) field switch"
This should help

Lori

-----Original Message-----
I have merged an excel workbook with Word and have the date fields layed
out dd/mm/yyyy in excel. They are automatically changed into mm/dd/yy
format in the mail merge.

ANy ideas how to stop this happening?

Thanks in advance.

Andrew



------------------------------------------------
 

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

Top