ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I change format of page numbers to letters in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/55529-how-do-i-change-format-page-numbers-letters-excel.html)

DonnaGoof

How do I change format of page numbers to letters in Excel?
 
I need to create page numbers for multi-page Excel spread sheets that include
subnumbers, which the client needs with some letter forms, as Page 2-f. Even
with an Excel manual and the Help function I can't find out how to do this.
My only alternative will be MANUALLY typing in those page numbers! Help!

Dave O

How do I change format of page numbers to letters in Excel?
 
What sequence of alpha numerics do you need? With the automatic
numbering provided in the headers/footers section I'm not sure how you
would manually enter the sequence. Where does page numbering appear,
and what is your desired outcome?


DonnaGoof

How do I change format of page numbers to letters in Excel?
 
The sequence would be, Page 1-(a, b, c, d, etc.) as far as it goes. The
document is currently 8 pages long, but more are anticipated. I can enter
the sequence except for the final LETTER. It must be a NUMBER. In Word, the
numbering protocol itself can be changes. I guess that's what I'm looking
for in Excel. It is required by our client. Page numbers are centered in
the footer. Thanks for whatever you can do. Donna

"Dave O" wrote:

What sequence of alpha numerics do you need? With the automatic
numbering provided in the headers/footers section I'm not sure how you
would manually enter the sequence. Where does page numbering appear,
and what is your desired outcome?




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

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