&[page]+2 not giving me 3....

I

ivanwms64

Greetings

I am using two versions of excel - one is excel 2000 where I us
the &[page]+2 to give me page 3 and continue numbering the page bu
when I send the document to a colleague using excel 2002 in win-x
instead of printing page 3, 4 , 5 it prints page 12, 22, 32, 42, 52 an
so on. Does ayone have a solution for this?

Iva
 
T

Trevor

In Excel 2002, there is an option on the File->Page Setup screen to start
page numbering at 3 instead of Auto. If that option also exists in 2000,
then you should be all set. Otherwise; I'm at an impass, too....
 
G

Gord Dibben

Ivan

Method 1. File>Page setup>First page number. Enter 3.

Method 2. With the Custom dialog box open, select the Insert Page No. icon.

You will get &[Page] just add + 2 and a space

i.e. &[Page]+2<sp> will start at page 3.

MUST enter the space!

Gord Dibben Excel MVP
 
Top