Page number on footers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to do a custom footer for a 3 page worksheet. I would like to
start numbering with Page 3. I read where I need to use &[Page)+ followed
by the number I want to add to the actual page number. For some reason this
is not working. On page one, if I use &[Page]+2, my page number ends up
being 12. What is going on? Any suggestions?
 
I am trying to do a custom footer for a 3 page worksheet. I would like to
start numbering with Page 3. I read where I need to use &[Page)+ followed
by the number I want to add to the actual page number. For some reason this
is not working. On page one, if I use &[Page]+2, my page number ends up
being 12. What is going on? Any suggestions?
Click to expand...

If you're talking about Excel Worksheets, you should ask the question
in one of the microsoft.public.excel newsgroups, rather than in this
one - which is for Microsoft Access.

That said - it's probably concatenating strings rather than adding
values. Try

&(Val([Page]) + 2)

and if that doesn't work - ask the Excel gurus!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top