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

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) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Thanks, i formatted it in Excel

See Mailmerge Percentage Formatting in the Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum:
https://www.msofficeforums.com/mail-...ps-tricks.html

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]