changing decimals to fractions

[olrustyxlsuser]

Hello,
Office 2007 (Enterprise) - Doing a mail merge where data from the data
source is changed from fraction to decimal in the merge. How can I change
the data back to fraction? Pretty sure I'll have to use a switch, but can't
find the correct format.
TIA.
John

 

[Graham Mayor]

From the Office button in Word, select Word Options and then go to the
Advanced tab > General and check the box against the "Confirm conversions
at open" item. Then when you attach the data source to the mail merge main
document, you will be given the option of using the DDE method of connection
which should read the data as you have it formatted in the Excel table.

Fields I'm afraid don't do fractions -
http://www.gmayor.com/formatting_word_fields.htm

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[olrustyxlsuser]

Thank you Graham. This works splendidly! I had problems connecting via DDE
a couple of times, but was able to fix the problem by slightly changing the
layout of the source file, ie. deleting empty rows, etc.
Much appreciated.
John

 

[Graham Mayor]

DDE is a bit flaky which is why it is no longer the default, but it is the
only way to bring in formatting that cannot be recreated in Word.

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>