Microsoft Office Forums Percentage letter merge

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-19-2018, 11:26 PM
Timhen Timhen is offline Percentage letter merge Windows 10 Percentage letter merge Office 2013
Novice
Percentage letter merge
 
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 Percentage letter merge Windows 10 Percentage letter merge Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,757
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 Percentage letter merge Windows 10 Percentage letter merge Office 2013
Novice
Percentage letter merge
 
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 online now Percentage letter merge Windows 7 64bit Percentage letter merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,480
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
Percentage letter merge Letter from Mail Merge Redundancy Record zidan3311 Mail Merge 3 10-04-2017 12:54 PM
Percentage letter merge 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
Percentage letter merge formating a percentage in a Mail Merge dkalsow Mail Merge 3 04-03-2012 03:38 PM
Percentage letter merge 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 04:22 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Search Engine Optimisation provided by DragonByte SEO v2.0.37 (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft