Page numbering problem

[Guest]

When I try and use automatic page numbering (i.e. &[Page]+1) for my headers
and footers excel does not add properly, it simply places the number I use
after the "+" sign next to a 1,2,3 etc.

example - if I try and make a footer say page 5 by using &[Page]+4 it will
actually print "page 14", page 6 by using &[Page]+5 will actually print "page
15", etc.

Does anyone know if there is a fix for this? (I am using Excel 2002 in
Windows XP)

I appreciate any help, Thanks!

 

[Guest]

You dont put &[Page]+1. But leave it simply as [&Page] but on the page tab
under page set up, you can code the first page number, which the default is
Auto. If you want to start with page 5, type the first page number cell as 5
and excel will number starting from 5. I use excel 2003 and do think that
this was available in 2002 version as well

 

[Guest]

you can't type in [Page] you have to use the special button(s) in the custom
footer section.

I know, it's really dum

 

[Guest]

upon reading it further, I understand what you're trying to do... I don't
think you can do it witin headers & footers...

Microsoft expeimented with 'Microsoft Binder' in earlier versions of office
to do what you are trying (print sections of a document from different apps).
It never really caught on though and I don't know if there's an alternative.

(*** The least slick, but reliable way to do this is to insert page breaks
in your word doc that will print the appropriate footers, then feed these
sheets back into the printer to print your spreadsheets..)

 

[Guest]

In the response that I gave to Suresh, I was able to do this when I had
windows 2000. It only began to be a problem in XP so I was wondering if this
was an issue that Microsoft had a fix for or if I have a setting in excel
that needs to be changed.
Any other suggestions?

Thank you both for the responses.

upon reading it further, I understand what you're trying to do... I don't
think you can do it witin headers & footers...

Microsoft expeimented with 'Microsoft Binder' in earlier versions of office
to do what you are trying (print sections of a document from different apps).
It never really caught on though and I don't know if there's an alternative.

(*** The least slick, but reliable way to do this is to insert page breaks
in your word doc that will print the appropriate footers, then feed these
sheets back into the printer to print your spreadsheets..)

When I try and use automatic page numbering (i.e. &[Page]+1) for my headers
and footers excel does not add properly, it simply places the number I use
after the "+" sign next to a 1,2,3 etc.

example - if I try and make a footer say page 5 by using &[Page]+4 it will
actually print "page 14", page 6 by using &[Page]+5 will actually print "page
15", etc.

Does anyone know if there is a fix for this? (I am using Excel 2002 in
Windows XP)

I appreciate any help, Thanks!

 

[Guest]

I have other pages in the document that I want to have different footers.
Excel help is actually what lists the &[Page}+number formatting option for
footers. I have had this work in the past when I had Office Prof on Windows
2000. This error only started to occur when I upgraded to XP. Any
suggestions?

You dont put &[Page]+1. But leave it simply as [&Page] but on the page tab
under page set up, you can code the first page number, which the default is
Auto. If you want to start with page 5, type the first page number cell as 5
and excel will number starting from 5. I use excel 2003 and do think that
this was available in 2002 version as well

When I try and use automatic page numbering (i.e. &[Page]+1) for my headers
and footers excel does not add properly, it simply places the number I use
after the "+" sign next to a 1,2,3 etc.

example - if I try and make a footer say page 5 by using &[Page]+4 it will
actually print "page 14", page 6 by using &[Page]+5 will actually print "page
15", etc.

Does anyone know if there is a fix for this? (I am using Excel 2002 in
Windows XP)

I appreciate any help, Thanks!

 

[Gord Dibben]

Make sure you have a <space> after the number.

[Page]+4<space>


Gord Dibben Excel MVP

 

[Guest]

Thank you very much! Someone should let Microsoft know to change the help so
that it lists that. In addition I was playing around with it and found that

&[Page]+4&]

works as well. Thank you though.

Make sure you have a <space> after the number.

[Page]+4<space>


Gord Dibben Excel MVP

When I try and use automatic page numbering (i.e. &[Page]+1) for my headers
and footers excel does not add properly, it simply places the number I use
after the "+" sign next to a 1,2,3 etc.

example - if I try and make a footer say page 5 by using &[Page]+4 it will
actually print "page 14", page 6 by using &[Page]+5 will actually print "page
15", etc.

Does anyone know if there is a fix for this? (I am using Excel 2002 in
Windows XP)

I appreciate any help, Thanks!