View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
clubin
 
Posts: n/a
Default Page numbering problem

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.

"Gord Dibben" wrote:

Make sure you have a <space after the number.

[Page]+4<space


Gord Dibben Excel MVP

On Fri, 18 Nov 2005 08:21:16 -0800, 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!