+ Reply to Thread
Results 1 to 2 of 2

Using Excel figures in Word Mail Merge - Need the correct decimal spaces to appear

  1. #1
    Registered User
    Join Date
    03-26-2014
    Location
    Delaware
    MS-Off Ver
    Excel 2010
    Posts
    3

    Using Excel figures in Word Mail Merge - Need the correct decimal spaces to appear

    Hello,

    I am generating a salary increase memo in Word for multipe persons. I inserted a mail merge using info from Excel. The problem I am having are the figures when they appear in the memo. For example, if a person's salary is $100,000.00, it coming up as $99999.9929 etc. - I need it to appear as $100,000.00.

    What do I need to do in Excel to stop this from happening?

    I thank you in advance for your help and responses.

    Here's an example of how it's turning out:

    Your increase will be effective with pay period ending 7/5/2014 (pay date of7/10/2014). Your new biweekly rate of pay will be 3846.1500000000001(99999.996299999999 annual equivalent).

    I need it to be just $3846.15 and $100,000.00.

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Using Excel figures in Word Mail Merge - Need the correct decimal spaces to appear

    See if the instructions at this website help:
    http://office.microsoft.com/en-us/wo...102809674.aspx

    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Mail Merge link with Excel - decimal problem
    By cicihk in forum Excel General
    Replies: 1
    Last Post: 06-06-2014, 05:15 PM
  2. Replies: 2
    Last Post: 01-22-2013, 11:37 AM
  3. merge with Word How can I get excel to mail merge zip codes plus 4 correctly?
    By Kathy at Sauder Feeds in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-30-2005, 07:05 AM
  4. decimal spaces toolong when mail merging from excel
    By punkyh in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 04-29-2005, 10:06 AM
  5. [SOLVED] Numbers after decimal point excel to word mail merge
    By Andy P in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-15-2005, 08:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1