word 2007

  • Thread starter Thread starter daten
  • Start date Start date
D

daten

when merging from excel to word, date changes from 01/01/01 to 1/01/2001.
Would like to keep date 01/01/01
 
You need to add a "Date/Time picture switch" to your merge field; in this
case, it would be:

\@ "MM/dd/yy"

or

\@ "dd/MM/yy"

depending on what your numbers represent.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org
 

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

Back
Top