How to create a numbering AA, AB, AC... instead of AA, BB, CC... in Word

See the following

https://www.officetooltips.com/word_2016/tips/how_to_create_a_numbering_aa__ab__ac..._instead_of_aa__bb__cc..._in_word.html

https://groups.google.com/g/microsoft.public.word.numbering/c/9E4T-8kz1Ho?pli=1

https://www.office-forums.com/threads/outline-numbering-sequence-a-z-aa-ab-ac.1828842/

The following is from an archive of ex-MVP Cindy Meister's website

Generate a number sequence like Excel uses to number columns Traditional outline numbering using alphabetic characters proceeds A...Z, AA, BB, CC. But most people these days are so accustomed to the sequence used for Excel columns (A...Z, AA, AB, AC) that they prefer this in their documents. It is even a requirement for legal documents in some counties / states.

No current version of Word supports the Excel-type numbering. But it can be achieved using SET and IF fields:

{ Quote { Set ABC { = { ABC } + 1 } }{ SET ABC2 { IF { ABC } > 26 "{ IF { = MOD({ ABC }, 26) } = 1 "{ = { ABC2 } + 1 }" "{ ABC2 }" }" "{ ABC2 }" } }{ SET ABC1 { IF ABC1 < 26 "{ = { ABC1 } + 1 }" "1" } }{ If { ABC } < 27 "{ ABC1 \* ALPHABETIC }" "{ ABC2 \* ALPHABETIC }{ ABC1 \* ALPHABETIC }" } }

To convert the above to fields, see Convert Text Representations of Fields to Working Fieldsin the Mailmerge Tips and Tricks thread in the Mailmerge forum:

https://www.msofficeforums.com/mail-...ps-tricks.html

The code there turns a text representation of a field code into a working field.

This isn't easy in Word, but you can do it with nested fields. The following example is a screen shot from an archived site, previously created and maintained by Cindy Meister:

Source: https://web.archive.org/web/20190831231705/http://homepage.swissonline.ch/cindymeister/NbrFAQ.htm#XLTypeNr