Results 1 to 3 of 3

Thread: Decimals (XP)

  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Decimals (XP)

    I have a source database in Excel that includes student's GPA scores - which have to be at least 2 decimal places. I'm importing all of this data into Word as labels - can't seem to get ONLY the 2 decimal places on the labels - get more than 5.

    Fix?

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

    Re: Decimals (XP)

    Are you using mail merge? If so, you have two options in Word:

    One option is to add a format switch to the merge fields:
    - Right-click a merge field.
    - Select Toggle Field Codes from the popup menu.
    - Insert the following before the closing brace } but after the merge field name.
    <code>
    # "0.00"
    </code>
    - Press F9 to hide the field code and to update the field.

    Another method:
    - In Word, select Tools | Options...
    - Activate the General tab.
    - Tick the "Confirm conversion at Open" check box.
    - Click OK.
    - Go back to step 3 of the mail merge wizard (task pane).
    - Click "Select a different list".
    - Locate your workbook again.
    - This time, you'll be prompted for a method to connect to the workbook.
    - Select "MS Excel worksheets via DDE (*.xls)", then click OK.
    - Continue as usual.
    The merge should now preserve the number formatting from Excel.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Decimals (XP)

    Thanks - I had no clue you could do that in Word - BUT

    turns out just using the "fixed" function in Excel to change the numbers to text worked just fine . . . sooooooooooooo

    Thanks again for your help

    Aunt linda

Posting Permissions

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