Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number of Pages in Footer
Thanks
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format page number in excel footer to start at a specific page # | Excel Discussion (Misc queries) | |||
How do I continuously number pages for the entire workbook? | Excel Discussion (Misc queries) | |||
Increment Date Based on Number of Pages Printed | Excel Discussion (Misc queries) | |||
How do i number pages in a header consequently | Excel Worksheet Functions | |||
How to print a worksheet but number the pages by workbook | Excel Discussion (Misc queries) |