April 9, 2024
Contribute to the Microsoft 365 and Office forum!
Click here to learn more 💡
Word Forum Top Contributors:
May 10, 2024
Word Forum Top Contributors:
RO
How do I mail merge percentages from excel?
I have Microsoft Office 2010 and during a mail merge I am unable to transfer percentages. I've tried multiple things. With the dynamic data exchange, it deletes my percentage fields and when I try to re add them they are no longer on the list. When trying
to change the code through SHIFT-F9 and adding \# 00.00 the percent is displayed as .03% instead of 3%. When I change the code from {={MERGEFIELD "Data"}*100\#0%} I get an error.
This thread is locked. You can vote as helpful, but you cannot reply or subscribe to this thread.
Report abuse
Details (required):
Thank you.
Reported content has been submitted
Answer
Your data then is 5.8512 which was truncated in Excel and displayed as percent?
Do you want it truncated in Word as well? The pictures will do that. Remember, though, the full number is there if you do any field math.
When I put that data in your field I get 585%.
With your first picture, I get 585.12%.
Without the multiplication I get 05.85%.
No error codes. You will get an error code if you leave out the space before the picture code or leave out the backslash.
Volunteering to "pay forward" the help I've received in the Microsoft user community.Do you want it truncated in Word as well? The pictures will do that. Remember, though, the full number is there if you do any field math.
When I put that data in your field I get 585%.
With your first picture, I get 585.12%.
Without the multiplication I get 05.85%.
No error codes. You will get an error code if you leave out the space before the picture code or leave out the backslash.
Charles Kenyon
Sun Prairie, Wisconsin
wordfaq[at]addbalance[dot]com
Legal site: https://addbalance.com
Report abuse
Details (required):
Thank you.
Reported content has been submitted
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Answer
What is your number in Excel (unformatted in Excel)?
When I use your code on data that is .03, I get 3%.
You may find the following useful.
Microsoft Word Field Maths Tutorial by Paul Edstein, MVP.
Volunteering to "pay forward" the help I've received in the Microsoft user community.When I use your code on data that is .03, I get 3%.
You may find the following useful.
Microsoft Word Field Maths Tutorial by Paul Edstein, MVP.
Numeric Format Switches in Fields from MS
It looks like you have that down, though.
Charles Kenyon
Sun Prairie, Wisconsin
wordfaq[at]addbalance[dot]com
Legal site: https://addbalance.com
Report abuse
Details (required):
Thank you.
Reported content has been submitted
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Question Info
Last updated May 15, 2024 Views 223 Applies to: