ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Number of Pages in Footer (https://www.excelbanter.com/excel-discussion-misc-queries/113306-number-pages-footer.html)

Ed

Number of Pages in Footer
 
Hello, I have right now in my Footer:

&[Page] / &[Pages] (which gives me "1 / 1" right now)

but this page would be after a cover page, so I would like to add 1 to the
page number and 1 to the number of pages... so then I tried:

&[Page]+1 / &[Pages]+1 which gives me 2 / 11 !

Ok so 2 is ok but not 11, how can I manage to add 1 to the number of pages?

thanks!


Ron de Bruin

Number of Pages in Footer
 
This is a bug in Excel
http://support.microsoft.com/kb/48198/en-us

Add a space after the 1


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Ed" wrote in message ...
Hello, I have right now in my Footer:

&[Page] / &[Pages] (which gives me "1 / 1" right now)

but this page would be after a cover page, so I would like to add 1 to the
page number and 1 to the number of pages... so then I tried:

&[Page]+1 / &[Pages]+1 which gives me 2 / 11 !

Ok so 2 is ok but not 11, how can I manage to add 1 to the number of pages?

thanks!




Ed

Number of Pages in Footer
 
Thanks for the tip Ron, I tried it but it doesn't work. I tried several
things now with the spaces and its the same, im using the Beta version 2007,
I don't know if that has something to do with it, anyways, thanks! I guess a
bug is a bug and there is not much to to about it.

,Ed

Ron de Bruin

Number of Pages in Footer
 
Hi Ed

I see that it 2007 it is not working the same as in older versions, the space is workig there.

Maybe you can check the new option in the page setup
"Different first page"


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Ed" wrote in message ...
Thanks for the tip Ron, I tried it but it doesn't work. I tried several
things now with the spaces and its the same, im using the Beta version 2007,
I don't know if that has something to do with it, anyways, thanks! I guess a
bug is a bug and there is not much to to about it.

,Ed




Ron de Bruin

Number of Pages in Footer
 
Hi Ed

If you are in printpreview it is not correct but if you go to
page layout view it is working. (with the space after the last 1)

I can't print on this machine to see the printout

Can you test it ????



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Ron de Bruin" wrote in message ...
Hi Ed

I see that it 2007 it is not working the same as in older versions, the space is workig there.

Maybe you can check the new option in the page setup
"Different first page"


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Ed" wrote in message ...
Thanks for the tip Ron, I tried it but it doesn't work. I tried several
things now with the spaces and its the same, im using the Beta version 2007,
I don't know if that has something to do with it, anyways, thanks! I guess a
bug is a bug and there is not much to to about it.

,Ed






Ed

Number of Pages in Footer
 
Hello Ron, well guess what?
Yeah in Page Layout View I do have "2 / 2" as I want, but when I print it I
get "2 / 1" this time... it's not working...

Ron de Bruin

Number of Pages in Footer
 
I send a bug report Ed

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Ed" wrote in message ...
Hello Ron, well guess what?
Yeah in Page Layout View I do have "2 / 2" as I want, but when I print it I
get "2 / 1" this time... it's not working...




Ed

Number of Pages in Footer
 
Thanks


All times are GMT +1. The time now is 11:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com