|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 10th, 2009, 03:00 PM
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
March 10th, 2009, 03:31 PM
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
March 10th, 2009, 03:40 PM
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
March 10th, 2009, 07:38 PM
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
