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