 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / August 2007changing decimals to fractions
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 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  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Hello, > Office 2007 (Enterprise) - Doing a mail merge where data from the data [quoted text clipped - 3 lines] > TIA. > John 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 > 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 [quoted text clipped - 12 lines] > > TIA. > > John 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. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Thank you Graham. This works splendidly! I had problems connecting > via DDE a couple of times, but was able to fix the problem by [quoted text clipped - 28 lines] >>> TIA. >>> John |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.