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
 
Top