You might try what is actually shown on my web page
{={Mergefield Percent_Increase} * 100 \# "0%"}
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
Harry H. wrote:
I am using Word 2003 to create letters the merge payroll data from an
Excel 2003 spreadsheet.
Graham Major's formatting instructions (
http://www.gmayor.com/formatting_word_fields.htm ) have helped
immensly to display the currency and date fields properly.
However, I can't seem to get the percentage format to work.
The suggested "{ ={MERGEFIELD "Percent_Increase" } * 100\* "0%" }"
renders "!Syntax Error, {"
If I use: { MERGEFIELD "Percent_Increase" * 100\* "0%" } it renders
"0%" for an input value of 5.00% (on the Excel spreadsheet).
If I use: { MERGEFIELD "Percent_Increase" * 100\* "0.00%" } it
renders "0.05%" for an input value of 5.00% (on the Excel
spreadsheet).
If I use: { MERGEFIELD "Percent_Increase" * 100\* "0.0%" } it renders
"0.1%" for an input value of 5.00% (on the Excel spreadsheet).
Note: All of the column names in the Excel spreadsheet show up in the
Word master document enclosed in quotation marks (i.e., ").
I've been trying many different combinations of the suggested
mergefield code, but to no avail. Basically, it appears that the
multiplication by 100 is not effective.
Any suggestions?