Fraction formatting for MERGEFIELD

Posted on 2012-08-30
Last Modified: 2012-09-06
When merging from Excel 2010 to Word 2010 I would like to format the Word document to show the same fraction that exists in the Excel cell.
eg: the Excel cell is formatted to show 5/8, but when this comes across to the Word doc the result is 0.625019.  
Is there a switch code for fractions?
Question by:kennysmith101
    LVL 22

    Accepted Solution

    I'm not sure if there is such a switch, but there is a work-around. Convert your fraction in excel to text. If it's in A1, use this formula:

    =TEXT(A1,"# ??/??")

    You can then use that column for your merge.


    Author Comment

    Will give it a try tomorrow.
    LVL 76

    Expert Comment

    Displaying as fraction involves some hidden rounding and some arbitrary decisions about the nearest fraction.  For instance 770/1000 is a fraction that is displayed as 7/9, while 769/1000 is displayed as 3/4 even though it is nearer to 7/9 than to 3/4.

    This complex decision making is not in Word field formatting logic.

    You can reproduce the formatting that is in the datasource by using a DDE connection. In Word Options, Advanced, General, tick the 'Confirm file format conversion on open'. Then ,when you select the datasource (Recipients), you will get a 'Confirm Data Source' dialogue. You need to select 'MS Excel Worksheets via DDE'. If it isn't in the list, tick the 'Show all' box.

    All the spreadsheet formatting, including fractions, will then be copied in the mail merge output.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
    Article by: Leon
    Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
    In a previous video Micro Tutorial here at Experts Exchange (, I explained how to get a free, one-month trial of Office …

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now