How can I add letters to page numbers in Excel.

[SwMC]

I have a multiple page workbook I am trying to add letters to page numbers in
the footer on an Excel 2007 worksheet.

ie: 1, 1a, 1b - I see in Word it is called chapters - I can't find a way to
format the page number in Excel.

 

[jaf]

Hi,
Excel is not Word. There are no chapters in Excel.

Word & Excel do get along quite well.
Perhaps you can output the spreadsheet to Word for printing.

John

 

[SwMC]

Instead of trying to format the page number. I inserted the tab name in the
footer to manipulate the page number formatting.