 |
 | 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 / March 2007Keeping the format from an Excell cell
When merging in an excell file that contains a quantity eg 2.34, it shows in the merge as 2.3400000002 or similar. Is there a way of preventing this please?  SignatureDave P Use a numeric switch on the field - 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 <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > When merging in an excell file that contains a quantity eg 2.34, it > shows in the merge as 2.3400000002 or similar. > > Is there a way of preventing this please? Hi Graham, Thanks for that, it certainly seems the right answer but I'm afraid I am still unsure as to how to apply your answer. Can you please explain exactly where I put this {MergeField} \#0.00 in relation to my <<Qty>> merge field that I insert into my WORD document? Thanks Dave P > Use a numeric switch on the field - > http://www.gmayor.com/formatting_word_fields.htm [quoted text clipped - 3 lines] > > > > Is there a way of preventing this please? Press ALT+F9 <<Qty>> will appear as {MERGEFIELD Qty} add the switch inside the bracket {MERGEFIELD Qty \# "0.00"} Press Alt +F9 then F9 to update. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Hi Graham, Thanks for that, it certainly seems the right answer but > I'm afraid I am still unsure as to how to apply your answer. Can you [quoted text clipped - 21 lines] >>> >>> Is there a way of preventing this please? Hi Graham Got it now thanks. Certainly not very easy to teach people new to Mailmerge eh? I teach Adults and thought I would show them merging data from a spreadsheet into a mailmerge. Why did I have to go and pick a quantity field? There really ought to be an easier way. Thanks again Dave SignatureDave P > Press ALT+F9 > <<Qty>> will appear as [quoted text clipped - 28 lines] > >>> > >>> Is there a way of preventing this please? From the Tools menu in Word, select Options and then go to the General tab 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 table. Note that DDE is less reliable which is one reason why Microsoft has changed the data connection method to read the raw data from Excel. Formatting fields is no big deal, but rather than insert the fields and modify them, it is much quicker and easier to add them from the keyboard using CTRL+F9 for the field boundaries. See http://www.gmayor.com/mail_merge_labels_with_word_xp.htm as a merge primer and also 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 <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Hi Graham > [quoted text clipped - 49 lines] >>>>> >>>>> Is there a way of preventing this please? |
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.