Page Numbering -Easy!!! 1

[luceze]

This may seem like a stupid question, but in excel 2000 is it possible to have page numbers in the footer starting with a certain page number such as 50 but in the header have &[page] of &[pages] start with 1. For example, a 3 page worksheet with the page numbers 50, 51, 52 in the footer and page 1 of 3, 2 of 3, 3 of 3 in the header.

Thanks,
Eric

 

[Hasit]

Not a stupid question - strange, but never stupid! X-)

And the answer is yes, you can:

&P+## Substitute a number for the number signs (#) to
increment the page numbers by that amount.

&P-## Substitute a number for the number signs (#) to
decrement the page numbers by that amount.

Don't bother using the &[Page] stuff in the footer, as the above will do it for you.

In the header, use the the standard &[Page] etc etc.

 

[luceze]

You the man!!!