data merge into word using excel spreadsheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JoJo - 24 Feb 2004 19:40 GMT

In previous versions of windows I used an Excel document
which contained a column of dates formatted to be shown
as text rather than numeric value. When merging with my
primary Word Document the format remained the same.

I have updated to Windows XP and when performing the
merge the data has reverted to a numeric value. Is it
possible to retain the format or to format the field in
the Word document?

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 25 Feb 2004 05:49 GMT

Press Alt+F9 to toggle on the field codes and add a formatting switch such
as \@ "dd-MMMM-yyyy" inside the closing } of the mergefield. Vary the
arrangement of the d, M and y to get the format that you require. MMM would
give Feb, MMMM gives February

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP

> In previous versions of windows I used an Excel document
> which contained a column of dates formatted to be shown
[quoted text clipped - 5 lines]
> possible to retain the format or to format the field in
> the Word document?

Reply to this Message