Using Letters as Page Numbers

kmaynard

New Member
Joined
Sep 30, 2006
Messages
3
Anyone know how to format page numbers in excel to use letters? You can do it in Word easily, but I'm not sure about excel. I need to use page numbers like A-1, B-1 etc.

Can anyone help?
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

irresistible007

Board Regular
Joined
Nov 24, 2005
Messages
173
Here is the way insert the footer... Page X of Y... it will display Page 1 of 100 (assuming you have 100 pages ...then click the curent page number if you are at 50th then 50... right click it and clik edit field and ther you are fied properties... let me know if you still cant
 

kmaynard

New Member
Joined
Sep 30, 2006
Messages
3
RE

Sorry, not following you. I'm into my spreadsheet that has 10 different pages. I click 'view' - headers and footers. I click on custom footers, but it won't let me edit or anything like that. Please advise.
 

kmaynard

New Member
Joined
Sep 30, 2006
Messages
3
not familiar with macros. Is there any way I can copy and paste that macro into my sheet?
 

Watch MrExcel Video

Forum statistics

Threads
1,112,883
Messages
5,543,019
Members
410,583
Latest member
gazz57
Top