View Single Post
 
Old 03-26-2012, 09:07 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi legg,

Unless you want values => 1 formatted differently, I don't see where the "less than 1 in value" comes into play.

To control percentage formatting in Word, add a formula and numeric picture switch to the mergefield, as follows:
• select your mergefield, which will look like «vekttall»;
• press Ctrl-F9 to wrap another field around it, thus { «vekttall» };
• edit the field so that you get {=«vekttall»*100 \# 0.00%}. This will force all the data to show as percentages, to two decimal places;
• position the cursor anywhere in this field and press F9 to update it;
• run your mailmerge.

Note: the precision of the displayed value is controlled by the '0.00'. You can use anything from '0' to '0.000000000000000'.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote