[Suwat Upathambhakul (Thailand)]

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

[Peter Jamieson]

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

[Doug Robbins - Word MVP]

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