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!