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:
But the resulting value rounds up to 26%
I would like 25%
How? ...TX
Stop rounding in Mail Merge
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Stop rounding in Mail Merge
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.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- Administrator
- Posts: 78493
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Stop rounding in Mail Merge
You can use
{ =INT({MERGEFIELD Contribution_Total_as_a_Percentage_of_In }*100) \# "0%" }
{ =INT({MERGEFIELD Contribution_Total_as_a_Percentage_of_In }*100) \# "0%" }
Best wishes,
Hans
Hans
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Stop rounding in Mail Merge
TX...works :)
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.