View Single Post
 
Old 04-18-2016, 07:13 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,374
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

Your document uses a formfield for the calculation; which is unnecessary and in some cases undesirable. If you unprotect the document, select the calculation formfield and press Shift-F9, you'll see:
{ FORMTEXT { =REDEMPTIONGROUP/OFFERGROUP }}
What you need to do is copy '=REDEMPTIONGROUP/OFFERGROUP' and paste it over 'FORMTEXT ', then delete { =REDEMPTIONGROUP/OFFERGROUP }. Having done that, you should see:
{ =REDEMPTIONGROUP/OFFERGROUP }
Edit this expression to show:
{ =REDEMPTIONGROUP/OFFERGROUP*100 \# "0.00%" }
then re-apply your forms protection.

You now have just a formula field for the calculation, instead of a formfield.

To see how to a wide range of calculations in Word, check out my Microsoft Word Field Maths Tutorial, at:
http://windowssecrets.com/forums/sho...Maths-Tutorial
or:
http://www.gmayor.com/downloads.htm#Third_party
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote