Formatting %s in Mail Merges

W

WPK

I am trying to format %s in my mail merge. I am looking for 19.4% but instead
get a long decimal (e.g., .1938948349304343). I have tried to use a numeric
picture switch like \# ##.00x but this gets me .194. I know that I can
multiply the field in Excel by 100 but I have several % fields and would like
to try to do it in the mail merge. Any good insight into solving this issue?
Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting %s in Mail Merges 1
Mail Merge Switch - Dollars to Words 0
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Auto Merge text from multiple sources 0
Document Merge Formatting Issue 0
Mail Merge skipping records/sending one at a time 0
Start a mail merge upon opening the document 1
ASK Field Formatting 1

Top