RE: Excel 2003 -??

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Auto Numbering is just like it says... Numbering. It does not know the
alphabet. You are not going to have a lot of luck on that one. As an Aside
what did you want it to do when it gets pas Z? Should it be AA or ???
--
HTH...

Jim Thomlinson


"MJ" wrote:

I am trying to use the Auto-Numbering feature but with alphabets:

what I need; to auto add the alphabet when i drag scroll down so it should
look like this:
12345A
12345B
12345C

Currently i just keep getting a copy of the first cell
12345A
12345A etc,.

any suggestions or ideas if that is possible in excel 2003
.

Relevant Pages

  • Auto Numbering sequence -- AA, AB instead of AA, BB?
    ... Is there an option to change the sequence of the auto numbering ... combined-alphabet when we've exceeded the 26-letter alphabet, ... My default recurring sequence seems to be AA, BB, CC, etc. ...
    (microsoft.public.word.docmanagement)
  • Re: Russell Has To Win
    ... I don't expect every jury vote to ... choosing their vote based on luck or by going through the alphabet or ... lol - and the alphabet guy was a doctor, ...
    (alt.tv.survivor)
  • Re: Shifting alphabets
    ... > For any given plaintext alphabet of length N, is it possible to find a ... > crypt alphabet arrangement that can NOT be shifted into a position ... Good luck! ...
    (sci.crypt)