Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Long Documents / February 2004

Tip: Looking for answers? Try searching our database.

Microsoft Word Formulas

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Liam Gibbs - 29 Feb 2004 04:24 GMT
I'm having a real tough time with doing formulas in Microsoft Word
2002. I've even tried using the Microsoft-provided examples, typing
them out word-for-word, but they don't seem to work as explained. When
I try something like { = 19.99 * 10 }, it comes out nothing. If I try
' Page { PAGE } of { = (47 - 1) + { NUMPAGES }', I get '1'. Should I
not get 'Page 1 of 66' or something? Anyway, these formulas are very
difficult for me to understand. What I need to do is take the number
of pages (NUMPAGES, I assume from what the help system tells me,
although I have yet to get a decent number back) and multiply that by
126. Does anybody know how this is done? Is there a decent,
non-Microsoft-written primer on their own formulas?
Graham Mayor - 29 Feb 2004 05:37 GMT
Fields are quite simple, but to make them easy to work with you should add a
personal toolbar to Word and put on it a couple of buttons to call a pair of
macros:

Sub FieldCodes()
   ActiveWindow.View.ShowFieldCodes = Not ActiveWindow.View.ShowFieldCodes
   Application.DisplayStatusBar = True
End Sub

(there is a keyboard equivament to this - ALT+F9)

The other is the example code at http://www.gmayor.com/installing_macro.htm
which explains how to add macros
and that macro has keyboard equivalents (CTRL+A then F9, but does not work
when the document has headers with fields)

The step you appear to be missing is the updating of the field

Press CTRL+F9 - this gives you a pair of brackets {}
Between them type = CTRL+F9
so you get {={}}
Between the second pair of brackets type Numpages and outside the bracket
type * 26 thus:

{ ={Numpages} * 26 }

Toggle the display - the field will be blank. Hit F9 or the toolbar button
and the display will show the page number * 26.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
    Graham Mayor -  Word MVP

     Web site www.gmayor.com
 Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I'm having a real tough time with doing formulas in Microsoft Word
> 2002. I've even tried using the Microsoft-provided examples, typing
[quoted text clipped - 7 lines]
> 126. Does anybody know how this is done? Is there a decent,
> non-Microsoft-written primer on their own formulas?
Dayo Mitchell - 29 Feb 2004 14:11 GMT
Just FYI, I think Tools | Customize, Commands, has a View Field Codes icon
to be put on the toolbar...  Does the macro to Show Field Codes do something
different?

DM (MacWord 2001)

> Fields are quite simple, but to make them easy to work with you should add a
> personal toolbar to Word and put on it a couple of buttons to call a pair of
[quoted text clipped - 24 lines]
> Toggle the display - the field will be blank. Hit F9 or the toolbar button
> and the display will show the page number * 26.
Graham Mayor - 29 Feb 2004 14:15 GMT
I have been known to miss these commands in the past :) This one will do
exactly the same I guess. It simply toggles the display on/off.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
    Graham Mayor -  Word MVP

     Web site www.gmayor.com
 Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> Just FYI, I think Tools | Customize, Commands, has a View Field Codes
> icon
[quoted text clipped - 33 lines]
>> Toggle the display - the field will be blank. Hit F9 or the toolbar
>> button and the display will show the page number * 26.
Dayo Mitchell - 29 Feb 2004 15:10 GMT
Well, I was figuring maybe you've been expert in Fields since before they
added the command to the user interface.  :)

Dayo

> I have been known to miss these commands in the past :) This one will do
> exactly the same I guess. It simply toggles the display on/off.
[quoted text clipped - 36 lines]
>>> Toggle the display - the field will be blank. Hit F9 or the toolbar
>>> button and the display will show the page number * 26.
Suzanne S. Barnhill - 29 Feb 2004 16:45 GMT
I added that to my toolbar back in the days when for some reason I could
never remember Alt+F9. It's still there and at least serves as a handy
reference to the view state of field codes.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Signature

Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://www.word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.


> Just FYI, I think Tools | Customize, Commands, has a View Field Codes icon
> to be put on the toolbar...  Does the macro to Show Field Codes do something
[quoted text clipped - 30 lines]
> > Toggle the display - the field will be blank. Hit F9 or the toolbar button
> > and the display will show the page number * 26.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.