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?

"Suresh" wrote:

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

"clubin" wrote:

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!