Stop rounding in Mail Merge

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Stop rounding in Mail Merge

Post by Rudi »

Hi,

If I have a number in Excel; 25.76952%
I want to have the resulting Word mail merge to ONLY show 25%
I am using this modified field code:
1.jpg
But the resulting value rounds up to 26%

I would like 25%

How? ...TX
You do not have the required permissions to view the files attached to this post.
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.
Top
User avatar
HansV
Administrator
Posts: 78494
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Stop rounding in Mail Merge

Post by HansV »

You can use

{ =INT({MERGEFIELD Contribution_Total_as_a_Percentage_of_In }*100) \# "0%" }
Best wishes,
Hans
Top
User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Stop rounding in Mail Merge

Post by Rudi »

TX...works :)
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.
Top

Return to “Word and other document processors”