![]() |
#2
|
||||
|
||||
![]()
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] |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
iiiiifffff | Word VBA | 16 | 06-04-2016 01:47 AM |
How to calculate a rolling year-to-date percentage by quarter as the year progresses | sleake | Excel Programming | 2 | 04-23-2015 11:51 AM |
Macro to find coloured text and replace with form-field/formtext containing that text | tarktran | Word VBA | 1 | 11-26-2014 08:12 AM |
![]() |
David C | Word | 1 | 10-24-2012 04:53 AM |
![]() |
LAssist2011 | Word | 5 | 12-14-2011 03:02 PM |