Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Oct 2007
    Thanked 0 Times in 0 Posts
    I am doing a mail merge in Word 2003 using a data source in Excel 2003. The merge works successfully but some of the formats are incorrect.

    I have some fields in Excel that contain numbers - the cells are formatted to have 2 decimal places. I also have some date fields, the date formats are dd-mmm-yy. When I merge the document in Word, the number cells (being merged into a Word table) have either 14 or 15 decimal places (14 for 3 digit numbers, 15 for 2 digit numbers. The date cells in Word end up in the format m/d/yyyy.

    Can anyone help me please - I need to have the information in a specific format.

    Thank you.

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Mt Macedon, Victoria, Australia
    Thanked 45 Times in 44 Posts
    You need to add formatting switches to the merge fields. Word merges in the actual stored values from Excel, not just the displayed value.

    See for example : this post or search Word Help for format field codes.

Posting Permissions

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