Help! Impossible numbering sequence Word 2002

[Lori]

I need to either use sequence codes or an numbering style
that will produce
A-Z (easy)
Following Z is
AA then
AB
AC
AD

etc. not AA, BB, CC, DD as Word does natively. I have
tried eveything I know-
thanks,
lori

 

[macropod]

Hi Lori,

You can do this using field coding. Here's an example that'll do what you
want:
{QUOTE
{SET A2Z{=MOD({SEQ ABC}-1,26)+1}}
{SET AA2ZZ{=INT(({SEQ ABC \c}-1)/26)}}
{IF{AA2ZZ \* ALPHABETIC}= " " "" {AA2ZZ \* ALPHABETIC}}{A2Z \* ALPHABETIC}
}

I've laid this field out with line breaks to help make its structure easier
to read than:
{QUOTE{SET A2Z{=MOD({SEQ ABC}-1,26)+1}}{SET AA2ZZ{=INT(({SEQ ABC
\c}-1)/26)}}{IF{AA2ZZ \* ALPHABETIC}= " " "" {AA2ZZ \* ALPHABETIC}}{A2Z \*
ALPHABETIC}}

Note that all of the field braces (ie {}) are created in pairs via Ctrl-F9 -
you can simply type them.

Cheers

 

[Lori]

I am (e-mail address removed)---- I tried to send you the
document with the code in it-(I tried for 2 hours) I
get the first line of
A
B
C
but when I get to Z
I get
just
A
B
C again-

I am obviously just ignorant when iur comes to field
codes- Could you send the code to the above address>
Much thanks,
lori

 

[macropod]

Solution emailed.

Cheers

I am (e-mail address removed)---- I tried to send you the
document with the code in it-(I tried for 2 hours) I
get the first line of
A
B
C
but when I get to Z
I get
just
A
B
C again-

I am obviously just ignorant when iur comes to field
codes- Could you send the code to the above address>
Much thanks,
lori

 

[CAndersen (Kimba)]

Solution emailed.

Well, I guess no one else really needed to know anyway...

 

[macropod]

You could do yourself a favour and read the earlier posts in this thread,
which gave the field coding that was emailed ...