Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
how to format percetanges from an Excel merge
I was able to correctly format my currency fields in a merge document, but
not percentages. I looked on the resource given in a former post, www.gmayor.com but when I applied the formatting given, nothing is happening. When I push Alt F9 I only get «0.00%» even though there is a number in the field it's supposed to be pulling from in the excel document. I have checked to ensure the field names match exactly. Can anyone give me an idea what I might be doing wrong? Thanks so much |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
how to format percetanges from an Excel merge
You may need to use Alt+F9 a second time to get the { MERGEFIELD fieldname }
to display. If you cannot get it to display by that method, try deleting the field and inserting it again from the list of merge fields or insert it manually by using Ctrl+F9 to insert the field delimiters { } and then manually type the field code inside of them. -- 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 "CourtneyS" wrote in message ... I was able to correctly format my currency fields in a merge document, but not percentages. I looked on the resource given in a former post, www.gmayor.com but when I applied the formatting given, nothing is happening. When I push Alt F9 I only get «0.00%» even though there is a number in the field it's supposed to be pulling from in the excel document. I have checked to ensure the field names match exactly. Can anyone give me an idea what I might be doing wrong? Thanks so much |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
how to format percetanges from an Excel merge
If you get «0.00%» you have put the switch and calculation in the wrong
place. Recheck the original instructions matches what you have done. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org CourtneyS wrote: I was able to correctly format my currency fields in a merge document, but not percentages. I looked on the resource given in a former post, www.gmayor.com but when I applied the formatting given, nothing is happening. When I push Alt F9 I only get «0.00%» even though there is a number in the field it's supposed to be pulling from in the excel document. I have checked to ensure the field names match exactly. Can anyone give me an idea what I might be doing wrong? Thanks so much |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
how to format percetanges from an Excel merge
Firstly, when I go to the website being referenced, it tells me to put in the
following in the field for percentages. (FundMonthly is my merge field name). {= FundMonthly \# "##%"} When I put this in, it gives me syntax error. In the rest of my merge, which is working correctly, the word MERGEFIELD appears within the paranthesis and I did not use = in any of my field switches, which looks like the format being given on many field switches on the website listed above. When I try a variation on the above, for example, {MERGEFIELD FundMonthly \# "##%"} still there is an error. I also found in my research somewhere a formula that had a *100 in it. Basically, what is the correct field switch syntax? My merge field name is FundMonthly. Thanks. "Graham Mayor" wrote: If you get «0.00%» you have put the switch and calculation in the wrong place. Recheck the original instructions matches what you have done. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org CourtneyS wrote: I was able to correctly format my currency fields in a merge document, but not percentages. I looked on the resource given in a former post, www.gmayor.com but when I applied the formatting given, nothing is happening. When I push Alt F9 I only get «0.00%» even though there is a number in the field it's supposed to be pulling from in the excel document. I have checked to ensure the field names match exactly. Can anyone give me an idea what I might be doing wrong? Thanks so much |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
how to format percetanges from an Excel merge
Take another look at Graham's website. It does NOT tell you to use {=
FundMonthly \# "##%"} The example on the site is { = { MERGEFIELD Amount } * 100 \# "0%" } If you want the result displayed to two decimal places, then use { = { MERGEFIELD FundMonthly } * 100 \# "0.00%" } Finally, you must use Ctrl+F9 to insert each pair of field delimiters { } -- 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 "CourtneyS" wrote in message ... Firstly, when I go to the website being referenced, it tells me to put in the following in the field for percentages. (FundMonthly is my merge field name). {= FundMonthly \# "##%"} When I put this in, it gives me syntax error. In the rest of my merge, which is working correctly, the word MERGEFIELD appears within the paranthesis and I did not use = in any of my field switches, which looks like the format being given on many field switches on the website listed above. When I try a variation on the above, for example, {MERGEFIELD FundMonthly \# "##%"} still there is an error. I also found in my research somewhere a formula that had a *100 in it. Basically, what is the correct field switch syntax? My merge field name is FundMonthly. Thanks. "Graham Mayor" wrote: If you get «0.00%» you have put the switch and calculation in the wrong place. Recheck the original instructions matches what you have done. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org CourtneyS wrote: I was able to correctly format my currency fields in a merge document, but not percentages. I looked on the resource given in a former post, www.gmayor.com but when I applied the formatting given, nothing is happening. When I push Alt F9 I only get «0.00%» even though there is a number in the field it's supposed to be pulling from in the excel document. I have checked to ensure the field names match exactly. Can anyone give me an idea what I might be doing wrong? Thanks so much |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I mail merge to EMAIL from MS Word AND add a pdf attachment | Mailmerge | |||
Mail Merge: Excel (XP) fields scrambled during merge | Mailmerge | |||
Format from Excel not being shown in mail merge | Mailmerge | |||
Mail Merge does not accept formatted cell of Excel | Mailmerge | |||
Extra digits in merge from Excel (Office 2003) | Mailmerge |