View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default 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