Fraction formatting for MERGEFIELD

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David Hall - 27 Dec 2005 13:06 GMT

Hi, I would like to format the Word Doc to show the same fration that exists
in the Excel cell.
eg: the Excel cell is formated to show 1/80, but when this comes across to
the Word Doc the result is 0.0125
Is there a switch code for fractions or do i need another method?

Thanks
i am using Excel 2003 and Word 2003.
David Hall

Reply to this Message

Graham Mayor - 27 Dec 2005 14:21 GMT

In this case, you need to use the DDE connection method to the Excel data -
see the Excel data section of
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Hi, I would like to format the Word Doc to show the same fration that
> exists in the Excel cell.
[quoted text clipped - 5 lines]
> i am using Excel 2003 and Word 2003.
> David Hall

Reply to this Message