Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
100% is merging as 1%
I am merging an Excel 2007 spreadsheet into Word 2007. The field is
{MERGEFIELD "FTE" * 100 \# "0.00%"} 100% merges as 1%; 67% merges as .67%. What am I doing wrong? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
100% is merging as 1%
You will do better with
{={MERGEFIELD "FTE"} * 100 \# "0.00%"} See http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Annette wrote: I am merging an Excel 2007 spreadsheet into Word 2007. The field is {MERGEFIELD "FTE" * 100 \# "0.00%"} 100% merges as 1%; 67% merges as .67%. What am I doing wrong? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
100% is merging as 1%
now it comes through as {=1%} instead of 100%
"Graham Mayor" wrote: You will do better with {={MERGEFIELD "FTE"} * 100 \# "0.00%"} See http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Annette wrote: I am merging an Excel 2007 spreadsheet into Word 2007. The field is {MERGEFIELD "FTE" * 100 \# "0.00%"} 100% merges as 1%; 67% merges as .67%. What am I doing wrong? |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
100% is merging as 1%
All the {} have to be the special "field code braces" that you can enter
using ctrl-F9, not the ones you can type on the keyboard. You can use Alt-F9 to reveal/hide the field codes. Peter Jamieson http://tips.pjmsn.me.uk Annette wrote: now it comes through as {=1%} instead of 100% "Graham Mayor" wrote: You will do better with {={MERGEFIELD "FTE"} * 100 \# "0.00%"} See http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Annette wrote: I am merging an Excel 2007 spreadsheet into Word 2007. The field is {MERGEFIELD "FTE" * 100 \# "0.00%"} 100% merges as 1%; 67% merges as .67%. What am I doing wrong? |