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 / November 2003

Tip: Looking for answers? Try searching our database.

Question on formulating Page no.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jack Ling - 31 Oct 2003 10:15 GMT
Hi,

I am using MS Word XP. I want to include page nos. at the
footer for all BUT the last page.

So, I tried to put in the following formula from INSERT -
> FUNCTIONS -> (choose IF, and type at the formula box) :

IF {PAGE}={NUMPAGES} "" "Page " & {PAGE} & " of " &
{NUMPAGES}

But the result is unexpected: it just shows up the "Page"

best regards,
jack ling
Leigh - 31 Oct 2003 10:26 GMT
Hi Jack,

From experience I would be in a section break after the
second last page, and then on the last page when putting
in your footer delete the number and it shouldn't delete
the rest.

Hope it works

>-----Original Message-----
>Hi,
[quoted text clipped - 13 lines]
>jack ling
>.
Robert M. Franz (RMF) - 31 Oct 2003 12:20 GMT
Hi Jack,

[..]
> From experience I would be in a section break after the
> second last page, and then on the last page when putting
> in your footer delete the number and it shouldn't delete
> the rest.

you can work with a section break here, but it isn't really necessary
...

> >-----Original Message-----
[..]
> >I am using MS Word XP. I want to include page nos. at the
> >footer for all BUT the last page.
[quoted text clipped - 6 lines]
> >
> >But the result is unexpected: it just shows up the "Page"

not unexpected: the moment you close the "" after Page, the else-branch
seems closed.

No need to "string-concatenate" what you want in the header, just append
all in one string:

{ IF { PAGE }={ NUMPAGES } "" "Page { PAGE } of { NUMPAGES }" }

Greetinx
.bob
..Word-MVP
Signature

/"\  ASCII Ribbon Campaign
\ /
 X        Against HTML
/ \     in e-mail & news

JACK LING - 01 Nov 2003 04:44 GMT
Hi Leigh,

thanks for Leigh's reply.

The break-into-section would solve the issue. But we have
tried and found that we encountered another issue using
this approach : when we print the whole document at one
go it is ok but there are cases we need to print/re-print
part of the document -> if we choose print ,e.g. page
3,4, the footer doesn't come correctly. We have to print
once for  page 3 (the current page) then go to page 4 and
print current page again then it seems ok.

thanks for Robert's answer as well.

However, I can't put in the whole formula. When I put in
the { before IF, the window's OK button already grey out.

{ IF { PAGE }={ NUMPAGES } "" "Page { PAGE } of {
NUMPAGES }" }

Or I was at the wrong place to put in the formula? I went
into INSERT -> FUNCTIONS -> CHOOSE IF -> THEN TYPE IN THE
FORMULA BOX -> CLIKC OK.

Without the outer { } signs for the given formula, the
result just shows "PAGE"

your help is much appreciated.
thanks again,
jack ling

>-----Original Message-----
>Hi Jack,
[quoted text clipped - 25 lines]
>>
>.
Robert M. Franz (RMF) - 01 Nov 2003 11:10 GMT
Hi Jack,

[..]
> The break-into-section would solve the issue. But we have
> tried and found that we encountered another issue using
[quoted text clipped - 4 lines]
> once for  page 3 (the current page) then go to page 4 and
> print current page again then it seems ok.

look in Word's help under Print sections, pages, etc. You have to
specify section and page range together ...


> However, I can't put in the whole formula. When I put in
> the { before IF, the window's OK button already grey out.
[quoted text clipped - 5 lines]
> into INSERT -> FUNCTIONS -> CHOOSE IF -> THEN TYPE IN THE
> FORMULA BOX -> CLIKC OK.

Ahh, you are there... Yes, I usually use the "direct approach" in the
text layer. Simply hit CTRL F9 for each pair of field brackets and write
the rest by hand, that's usually faster (for a simple field) and simpler
(for complex ones).

Greetinx
.bob
..Word-MVP
Signature

/"\  ASCII Ribbon Campaign
\ /
 X        Against HTML
/ \     in e-mail & news

 
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.