Using Letters as Page Numbers

[kmaynard]

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?

 

[irresistible007]

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]

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.

 

[xapie128]

See if this link helps:
http://exceltips.vitalnews.com/Pages/T0206_Changing_Page_Number_Format.html

 

[kmaynard]

not familiar with macros. Is there any way I can copy and paste that macro into my sheet?