Number A, B, C, then AA, AB, AC though BZ

I

ilene

trying to use ListNum Fields, but I going from Z to AA,
BB, CC, etc; NOT AA, AB, AC, AD

is this do-able?

thanks

ilene
 
M

macropod

Hi Ilene,

Try a field coded as:
{QUOTE{SET A2Z{=MOD({SEQ ABC}-1,26)+1}}{SET AA2ZZ{=INT(({SEQ ABC
\c}-1)/26)}}{IF{AA2ZZ \* ALPHABETIC}= " " "" {AA2ZZ \* ALPHABETIC}}{A2Z \*
ALPHABETIC}}

Cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word 2007: Multi-level lists 10
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Auto Numbering sequence -- AA, AB instead of AA, BB? 1
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
How - (aa), (ab), (ac) 1
long alphabetical list 1
How to change alpha numbering? - X, Y, Z, A1, B1, C1.... 1
Pull data from 2 different Arrays in one cell 1

Top