Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge from Excel
My mail merge returns a percentage as 0.17563826086956522 instead of 18%.
How do I fix this? Thanks |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge from Excel
See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at http://www.gmayor.com/formatting_word_fields.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Jenny" wrote in message ... My mail merge returns a percentage as 0.17563826086956522 instead of 18%. How do I fix this? Thanks |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge from Excel
Ok - I can now view the % sign. However, I still need to get it from .17% to
17.56%. Please don't direct me to Mayor's site again - I've look through that site but I can't find what I need. "Doug Robbins - Word MVP" wrote: See "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at http://www.gmayor.com/formatting_word_fields.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Jenny" wrote in message ... My mail merge returns a percentage as 0.17563826086956522 instead of 18%. How do I fix this? Thanks |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge from Excel
If you want 0.1756 etc. to appear as 17.56% then use
{ ={ MERGEFIELD mypercentage }*100 \#0.00% } If you want it to appear as 18% then use { ={ MERGEFIELD mypercentage }*100 \#0% } where all the {} are the special field code braces that you can insert using ctrl-F9 -- Peter Jamieson http://tips.pjmsn.me.uk "Jenny" wrote in message ... Ok - I can now view the % sign. However, I still need to get it from .17% to 17.56%. Please don't direct me to Mayor's site again - I've look through that site but I can't find what I need. "Doug Robbins - Word MVP" wrote: See "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at http://www.gmayor.com/formatting_word_fields.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Jenny" wrote in message ... My mail merge returns a percentage as 0.17563826086956522 instead of 18%. How do I fix this? Thanks |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge from Excel
Peter - that's great! How about when you want to merge data from excel and it
does not show up properly. For example; we are merging a mailing list half of which has the extension for the Zip code of (55503-4783) and half are just the zip. It only merges the first half of the zip codes without the dash and the rest are set to zero. Is there a way to fix this? "Peter Jamieson" wrote: If you want 0.1756 etc. to appear as 17.56% then use { ={ MERGEFIELD mypercentage }*100 \#0.00% } If you want it to appear as 18% then use { ={ MERGEFIELD mypercentage }*100 \#0% } where all the {} are the special field code braces that you can insert using ctrl-F9 -- Peter Jamieson http://tips.pjmsn.me.uk "Jenny" wrote in message ... Ok - I can now view the % sign. However, I still need to get it from .17% to 17.56%. Please don't direct me to Mayor's site again - I've look through that site but I can't find what I need. "Doug Robbins - Word MVP" wrote: See "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at http://www.gmayor.com/formatting_word_fields.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Jenny" wrote in message ... My mail merge returns a percentage as 0.17563826086956522 instead of 18%. How do I fix this? Thanks |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge from Excel
You didn't look close enough. The quoted page covers exactly the
circumstances you outline - try looking under the sub heading 'Percentages' -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Jenny wrote: Ok - I can now view the % sign. However, I still need to get it from .17% to 17.56%. Please don't direct me to Mayor's site again - I've look through that site but I can't find what I need. "Doug Robbins - Word MVP" wrote: See "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at http://www.gmayor.com/formatting_word_fields.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Jenny" wrote in message ... My mail merge returns a percentage as 0.17563826086956522 instead of 18%. How do I fix this? Thanks |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to merge Excel chart for mass Word Mail Merge for employees | Mailmerge | |||
ExcelWord Mail merge transfers 16 digits when Excel shows only 3 | Mailmerge | |||
mail merge from excel-date in excel January 1, 2005 -merged dbase. | Mailmerge | |||
How to convert a mail merge document back to excel after mail mer | Microsoft Word Help | |||
Insert Merge Field problem with Word-Mail Merge from Excel documen | Microsoft Word Help |