Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word Mail Merge,Recipient No= 2 digit (Excel), wrong Return value
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word Mail Merge,Recipient No= 2 digit (Excel), wrong Return value
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 wrote in message ... 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 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word Mail Merge,Recipient No= 2 digit (Excel), wrong Return value
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 wrote in message ... 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I set up a mail merge recipient list in Word, not Access . | Microsoft Word Help | |||
Merge fields in Word pulling data from wrong Excel Columns. Help m | Mailmerge | |||
Change a recipient list in Word mail merge? It won't let me do. | Mailmerge | |||
Formating Mail Merge of 10 digit numbers to have parenthasis+dash | Mailmerge | |||
Word Mail Merge Recipient List | Mailmerge |