Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Oct 2003
    Posts
    33
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Merging $$$ Currency (2002)

    I am trying to take a file from Excel that has a column with prices in them, and mail merge into word to create labels/price tags on an Avery 5160 label. I cannot seem to import/merge the dollar $ign and any zero's behind the decimal point. What I get when I merge $1.70 is "1.7"

    Any ideas????

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

    Re: Merging $$$ Currency (2002)

    You will have to re-do the formatting in Excel. Right-click the price merge field (in the merge document) and select Toggle Field Codes. You will see something like

    { MERGEFIELD "Price" }

    Insert a format switch before the closing bracket:

    { MERGEFIELD "Price" # "$ 0.00" }

    Then right-click the field again and select Toggle Field Codes. If you were already looking at a preview of the merged data, press F9 to update the field.

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Merging $$$ Currency (2002)

    You need to use the # Numeric Picture switch to set the formatting. Unfortunately in 2002 it is a fair bit more difficult to insert the switch from the wizard. To find out more about the switches do a search in Word Help on numeric picture switch.
    Wendell

Posting Permissions

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