Can not change date format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wig - 20 Feb 2004 10:26 GMT

I am running a simple mail merge from Excel to Word 2003. After merging the documents I find that word has changed the date format from 20 February 2004 to 2/20/04 ( back to front in Australia) and very confusing to my clients. However I can not change the format back to how I would like it in the master document. I have changed the language default in both programs & in Control panel. I have deleted the field and re-inserted it, with no effect. Help.

Reply to this Message

Graham Mayor - 20 Feb 2004 14:48 GMT

See http://www.gmayor.com/formatting_word_fields.htm

In this case use {Mergefield datefieldname \@ "d MMMM yyyy"}

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I am running a simple mail merge from Excel to Word 2003. After
> merging the documents I find that word has changed the date format
[quoted text clipped - 3 lines]
> changed the language default in both programs & in Control panel. I
> have deleted the field and re-inserted it, with no effect. Help.

Reply to this Message

Wig - 21 Feb 2004 00:56 GMT

Thanks for your help Graham.

Reply to this Message

Graham Mayor - 21 Feb 2004 06:06 GMT

> Thanks for your help Graham.

You are welcome

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<

Reply to this Message