How do I use alpha page numbers (e.g., B-3a, B-3b, B-3c, etc.) in.

[Guest]

I am using Excel 2003 and need to use incrementing alpha page numbers (e.g.,
B-3a, B-3b, B-3c, etc.). Excel 2003 help only refers to numeric page numbers.
Is there a way to format the page numbers to use incrementing alpha page
numbers?

 

[BobT]

I was hoping to see a better reply to your question, but a
day has gone by so here is my $0.02.

If you must, you can always similate the footer in the
worksheet, just have to be consistent with row heights,
etc.

This might be more trouble than it's worth, but if want to
try here's a formula that might help.

=IF(QUOTIENT(COLUMN()-1,26)=0,"",CHAR(QUOTIENT(COLUMN()-
1,26)+96))&CHAR(IF(MOD(COLUMN(),26)=0,26,MOD(COLUMN(),26))
+96)

This will always return the the letter of the column it is
placed in. You can trade out the COLUMN() calls for a
pointer to a page number (numeric) and it will return a
for 1, b for 2, etc.

Hoping you get a better response
Bob

 

[Earl Kiosterud]

PT,

A macro could go through and build the page numbers as you require, in a
cell instead of in the actual header or footer.