Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Crestview Hills, Kentucky, USA
    Posts
    84
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail Merge Date Format (Word/Excel 03 SP2)

    After changing to a new computer, suddenly my mailmerge has changed the date format. In the Excel datasheet, the data is "February 28, 2006." In the Word merged document, the date appears "2/28/06."

    I've tried modifying the mergefield code as suggested in previous posts, but I can't seem to fix the date format.

    Any suggestions?

    Thanks,
    Craig.

  2. #2
    Star Lounger
    Join Date
    Jan 2001
    Location
    Crestview Hills, Kentucky, USA
    Posts
    84
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge Date Format (Word/Excel 03 SP2)

    I got it! Kept tinkering with the field code. Thanks, again, to HansV and his post of 26-May-04. I believe I was using field codes for an earlier version of Word & Excel.

    Thanks for this excellent Board!

    Craig.

  3. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Mail Merge Date Format (Word/Excel 03 SP2)

    Hi Craig,

    It might also be worthwhile checking that you're PC's Regional Settings are using the right date/time format.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •