View Single Post
  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default 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?