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?

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(COLUM N(),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

-----Original Message-----
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?
.

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.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"PT" wrote in message
...
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?