Word Mail Merge,Recipient No= 2 digit (Excel), wrong Return value Suwat Upathambhakul (Thailand) 11/11/2008 1:46:07 PM Need help, in Quality Control department (Pharmaceutical Factory), would like to store Analysis Result (all products) in Excel file e.g. Result of Active ingredient = 92.30 %. And prepare Certificate of Analysis by using Word 2007 under Mail Merge, but we found that % Active ingredient will show as 92.300000000001 (wrongly return value), we intend to show result as 92.30 or 92.300 We really appreciated if you advise how to fix such problem or recommend another program to be used for this purpose. Thanks and Regards, Suwat U. 11/11/2008 20.45

Re: Word Mail Merge,Recipient No= 2 digit (Excel), wrong Return value "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 11/11/2008 7:15:18 PM Use Alt-F9 to show the field code. Where you see { MERGEFIELD mynumber } add "\#0.00" to give you { MERGEFIELD mynumber \#0.00 } (You can delete \*Mergeformat if you see that in the field code) -- Peter Jamieson http://tips.pjmsn.me.uk "Suwat Upathambhakul (Thailand)" <Suwat Upathambhakul (Thailand)[ at ]discussions.microsoft.com> wrote in message news:4B5A2612-A84D-420D-A8D5-A6AF0B6DC43C[ at ]microsoft.com... [Quoted Text] > Need help, in Quality Control department (Pharmaceutical Factory), would > like > to store Analysis Result (all products) in Excel file e.g. Result of > Active > ingredient = 92.30 %. And prepare Certificate of Analysis by using Word > 2007 > under Mail Merge, but we found that % Active ingredient will show as > 92.300000000001 (wrongly return value), we intend to show result as 92.30 > or > 92.300 > > We really appreciated if you advise how to fix such problem or recommend > another program to be used for this purpose. > > Thanks and Regards, > Suwat U. 11/11/2008 20.45

Re: Word Mail Merge,Recipient No= 2 digit (Excel), wrong Return value "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 11/11/2008 7:21:09 PM You need to add a \# ##.000 formatting switch inside the closing } of the mail merge field that will be revealed when you use Alt+F9 to toggle on the display of the field codes in the mail merge main document. For more information, see the article "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at: http://www.gmayor.com/formatting_word_fields.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Suwat Upathambhakul (Thailand)" <Suwat Upathambhakul (Thailand)[ at ]discussions.microsoft.com> wrote in message news:4B5A2612-A84D-420D-A8D5-A6AF0B6DC43C[ at ]microsoft.com... [Quoted Text] > Need help, in Quality Control department (Pharmaceutical Factory), would > like > to store Analysis Result (all products) in Excel file e.g. Result of > Active > ingredient = 92.30 %. And prepare Certificate of Analysis by using Word > 2007 > under Mail Merge, but we found that % Active ingredient will show as > 92.300000000001 (wrongly return value), we intend to show result as 92.30 > or > 92.300 > > We really appreciated if you advise how to fix such problem or recommend > another program to be used for this purpose. > > Thanks and Regards, > Suwat U. 11/11/2008 20.45