Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Cone Cone is offline
external usenet poster
 
Posts: 7
Default Date field in Excel loses format in Word merge

I have an Excel list that contains a numeric date field (I can clear the
formats from the field contents and I can see the underlying serial numbers).
The field is formatted using mmmm d, yyyy, which is the format I want to see
in the Word document. Problem: the Word document shows the contents of the
field as m/d/yyyy. How do I keep the original Excel format? (Using Excel
and Word 2002). Thanks.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Date field in Excel loses format in Word merge

Use a date switch on the merge 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


Cone wrote:
I have an Excel list that contains a numeric date field (I can clear
the formats from the field contents and I can see the underlying
serial numbers). The field is formatted using mmmm d, yyyy, which is
the format I want to see in the Word document. Problem: the Word
document shows the contents of the field as m/d/yyyy. How do I keep
the original Excel format? (Using Excel and Word 2002). Thanks.



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
US date format in merge field Michelle Mailmerge 4 January 30th 07 03:52 PM
How do I import & format to fit excel date into word KMWordExcelIssues Page Layout 1 August 26th 06 03:17 AM
Merge from excel loses formatting Craig Mailmerge 3 February 24th 06 04:21 PM
Merge loses "symbol" character when taken from an excel spreadshee Frustrated Mailmerge 4 April 5th 05 05:50 PM
Date issue merging from Excel field in Date format to Word Barb Reinhardt Mailmerge 1 December 17th 04 07:34 AM


All times are GMT +1. The time now is 07:15 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"