(Msg. 1) Posted: Tue Nov 11, 2008 5:46 am
Post subject: Word Mail Merge,Recipient No= 2 digit (Excel), wrong Return value Archived from groups: microsoft>public>word>mailmerge>fields (more info?)
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.
(Msg. 2) Posted: Tue Nov 11, 2008 7:15 pm
Post subject: Re: Word Mail Merge,Recipient No= 2 digit (Excel), wrong Return value [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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)
"Suwat Upathambhakul (Thailand)" <Suwat Upathambhakul
(Thailand)@discussions.microsoft.com> wrote in message
news:4B5A2612-A84D-420D-A8D5-A6AF0B6DC43C@microsoft.com...
> 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
(Msg. 3) Posted: Wed Nov 12, 2008 3:05 am
Post subject: Re: Word Mail Merge,Recipient No= 2 digit (Excel), wrong Return value [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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:
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)@discussions.microsoft.com> wrote in message
news:4B5A2612-A84D-420D-A8D5-A6AF0B6DC43C@microsoft.com...
> 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
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office