Formatting Date in Merge

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "swimdad16" <swimdad16@xxxxxxxxx>
Date: Tue, 23 May 2006 14:24:38 GMT

I am merging from an Excel File into a Word Document.

Everything works except for a date field. I have it formatted as MM/DD/YY in
Excel but the merge displays it as YYYY-MM-DD HH:MM:SS

What do I need to do to display MM/DD/YY in the merge?

.

Follow-Ups:
- Re: Formatting Date in Merge
  - From: Peter Jamieson

Prev by Date: Re: Using DDE as source in mail merge
Next by Date: Re: MailMerge - Word 2000
Previous by thread: Re: Moving addresses round on mail merge labels?
Next by thread: Re: Formatting Date in Merge
Index(es):
- Date
- Thread

Relevant Pages

Data truncated when merging from Excel to Word.
... My data is truncated when I am merging from an excel file to a word document. ... I have merged this large of cells before with no problem, ...
(microsoft.public.word.mailmerge.fields)
Excel serial date formats
... I am merging an Excel file into a Word document. ... Excel file, and the formatting doesn't transfer to Word. ...
(microsoft.public.word.mailmerge.fields)