Merge Field w/Date

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

In Word 2003 when using Mail Merge on a form, one of the merge items is a
date. The data source is an Excel spreadsheet where the cell is formatted as
text and the date manually typed as March 1, 2009 but when it's merged into
the Word form the date comes out as 3/1/2009. Is there a way to change the
date format of that merge field?
 
See the Help topic "Date-Time Picture (\@) field switch" for instructions on
how to add the appropriate switch to your mergefield. In this case, you want
\@ MMMM d, yyyy.

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