[PeterG]

I have a excel list of information to mail merge in word 2007

The ORDERDATE field in word the formatting of the date & month is reversed
like a US Date.

Need to format Date as dd/mm/yy format.

Thanks

[Graham Mayor]

Add a date formatting switch to the field - see
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Peterg wrote:
I have a excel list of information to mail merge in word 2007

The ORDERDATE field in word the formatting of the date & month is
reversed like a US Date.

Need to format Date as dd/mm/yy format.

Thanks

[Henry]

We are having the same issue with Word 2007 not bringing the Excel formatting
we have set in the Excel file.

While we can do the steps you recommend, we did not have this issue with
Word 2003. Are we missing something or did Word 2007 take a step backwards?

We hope you or some of the Microsoft gurus will reply.

Thanks.
--
Henry


"Graham Mayor" wrote:

Add a date formatting switch to the field - see
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Peterg wrote:
I have a excel list of information to mail merge in word 2007

The ORDERDATE field in word the formatting of the date & month is
reversed like a US Date.

Need to format Date as dd/mm/yy format.

Thanks

[Suzanne S. Barnhill]

Actually, this changed in Word 2002, when MS changed the connection method
from DDE to OLEDB, but you can still use DDE; see
http://homepage.swissonline.ch/cindy...002/MM2002.htm.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"Henry" wrote in message
...
We are having the same issue with Word 2007 not bringing the Excel
formatting
we have set in the Excel file.

While we can do the steps you recommend, we did not have this issue with
Word 2003. Are we missing something or did Word 2007 take a step
backwards?

We hope you or some of the Microsoft gurus will reply.

Thanks.
--
Henry


"Graham Mayor" wrote:

Add a date formatting switch to the field - see
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Peterg wrote:
I have a excel list of information to mail merge in word 2007

The ORDERDATE field in word the formatting of the date & month is
reversed like a US Date.

Need to format Date as dd/mm/yy format.

Thanks