Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    thousands separator in mail merge field for dollar (2003)

    We have some dollar figures in an excel data source that we need to use in a merge letter. How can we get the merged field to show the thousands separator with numbers? The data source is an excel spreadsheet that has the cells formatted for currency with the thousands separator. That separator doesn't pull through to the word merge field.

    I can't find a way to do this. It must be something simple! Is there a switch for the merge field code??

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: thousands separator in mail merge field for dollar (2003)

    Select Tools | Options...
    Activate the General tab.
    Tick the "Confirm conversion at Open" check box.
    Click OK.
    Return to step 3 of the Mail Merge Wizard.
    Click Browse... / Select a diiferent list...
    When you select the workbook, you'll be asked which method to use to connect to the data source.
    Do not select the default method (OLE DB), but DDE or Conversion.
    Using either DDE or Conversion will preserve number formatting.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: thousands separator in mail merge field for dollar (2003)

    Voila!! That's just what I was looking for. Thank you!!!

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

    Re: thousands separator in mail merge field for dollar (2003)

    Hi Melanie,

    Another way is to add a numeric picture switch to the mergefield code. If you select the mergefield and press Shift-F9, you'll see something like:
    {MERGEFIELD Amount}
    Simply add a switch like '# $,0.00' to the mergefield, so that you have:
    {MERGEFIELD Amount # $,0.00}
    then press F9 to update. One potential advantage of this approach is that you can have a different data format in your merged document than you have in the source.

    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
  •