Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 06-19-2018, 11:26 PM
Timhen Timhen is offline Windows 10 Office 2013
Novice
 
Join Date: Jun 2018
Posts: 2
Timhen is on a distinguished road
Default Percentage letter merge


Hi All

Having some issues with a mail merge percentage formatting

My data is coming in as 0,6666666667 instead of 70% which is stated in Excel

is there a way to change the data formatting? It needs to show percentages

I am using Office 2013

Any help appreciated.

Thanks
Reply With Quote
  #2  
Old 06-20-2018, 01:59 AM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,702
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
Default

Mail merge reads the underlying data from Excel, not the displayed format. You need to use a calculated field construction { ={ MERGEFIELD Fieldname } * 100 \# "0%"}
(see http://www.gmayor.com/formatting_word_fields.htm )
__________________
Graham Mayor - MS MVP (Word)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 06-20-2018, 03:38 AM
Timhen Timhen is offline Windows 10 Office 2013
Novice
 
Join Date: Jun 2018
Posts: 2
Timhen is on a distinguished road
Default

Thanks, i formatted it in Excel
Reply With Quote
  #4  
Old 06-20-2018, 05:31 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,191
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

See Mailmerge Percentage Formatting in the Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum:
http://www.msofficeforums.com/mail-m...ps-tricks.html
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Letter from Mail Merge Redundancy Record zidan3311 Mail Merge 3 10-04-2017 12:54 PM
How do I mail merge multiple rows into one letter? SusiLouhh Mail Merge 1 03-17-2017 09:03 PM
Mail Merge Letter ChrisMcGann Mail Merge 2 10-23-2013 08:58 AM
formating a percentage in a Mail Merge dkalsow Mail Merge 3 04-03-2012 03:38 PM
Merge excel info into word letter. curatorfm Mail Merge 1 03-20-2011 04:26 AM


All times are GMT -7. The time now is 01:40 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft