Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
Hi,
I have 41% in my data source (Excel) and it displays 0.41354836739 in Word (my letter). I got a message Syntax Error when I try to correct the % formatting. {={MERGEFIELD PROD}*100\#"0%"} Please help me to fix it. Thanks Chi |
#2
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
Chi,
Try the following: {MERGEFIELD PROD}*100 \# "0%"} Watch the spacing, there should be a space between "*100" & the "\", and "#" & "0%" -- Add MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) message rule Previous Text Snipped to Save Bandwidth When Appropriate "Chi" wrote in message ... Hi, I have 41% in my data source (Excel) and it displays 0.41354836739 in Word (my letter). I got a message Syntax Error when I try to correct the % formatting. {={MERGEFIELD PROD}*100\#"0%"} Please help me to fix it. Thanks Chi |
#3
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
Hi Rich,
I tried it and I got 0% as result. Please help Thank you very much! Chi "Rich/rerat" wrote: Chi, Try the following: {MERGEFIELD PROD}*100 \# "0%"} Watch the spacing, there should be a space between "*100" & the "\", and "#" & "0%" -- Add MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) message rule Previous Text Snipped to Save Bandwidth When Appropriate "Chi" wrote in message ... Hi, I have 41% in my data source (Excel) and it displays 0.41354836739 in Word (my letter). I got a message Syntax Error when I try to correct the % formatting. {={MERGEFIELD PROD}*100\#"0%"} Please help me to fix it. Thanks Chi |
#4
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
The field construction that you require is
{ = { MERGEFIELD PROD } * 100 \# "0%" } Each pair of field delimiters { } must be inserted by using Ctrl+F9 -- 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, originally posted via msnews.microsoft.com "Chi" wrote in message ... Hi Rich, I tried it and I got 0% as result. Please help Thank you very much! Chi "Rich/rerat" wrote: Chi, Try the following: {MERGEFIELD PROD}*100 \# "0%"} Watch the spacing, there should be a space between "*100" & the "\", and "#" & "0%" -- Add MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) message rule Previous Text Snipped to Save Bandwidth When Appropriate "Chi" wrote in message ... Hi, I have 41% in my data source (Excel) and it displays 0.41354836739 in Word (my letter). I got a message Syntax Error when I try to correct the % formatting. {={MERGEFIELD PROD}*100\#"0%"} Please help me to fix it. Thanks Chi |
#5
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
Hi Doug,
Thank you very much! it works perfectly! Chi "Doug Robbins - Word MVP" wrote: The field construction that you require is { = { MERGEFIELD PROD } * 100 \# "0%" } Each pair of field delimiters { } must be inserted by using Ctrl+F9 -- 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, originally posted via msnews.microsoft.com "Chi" wrote in message ... Hi Rich, I tried it and I got 0% as result. Please help Thank you very much! Chi "Rich/rerat" wrote: Chi, Try the following: {MERGEFIELD PROD}*100 \# "0%"} Watch the spacing, there should be a space between "*100" & the "\", and "#" & "0%" -- Add MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) message rule Previous Text Snipped to Save Bandwidth When Appropriate "Chi" wrote in message ... Hi, I have 41% in my data source (Excel) and it displays 0.41354836739 in Word (my letter). I got a message Syntax Error when I try to correct the % formatting. {={MERGEFIELD PROD}*100\#"0%"} Please help me to fix it. Thanks Chi |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
percentage | Tables | |||
percentage mail merge | Mailmerge | |||
Percentage in form field | Tables | |||
Mail Merge Percentage | Mailmerge | |||
decimal to percentage | New Users |