Excel 2003 -??
Hi
You can't do it with Autonumbering, but the following formula should work.
This assumes you want to cycle through A to Z, then step the number up by 1,
and repeat the process.
=SUBSTITUTE(12345+INT(ROW(A26)/26)
&CHAR(MOD(ROW(A26),26)+64),"@","Z")
Once you have entered the formula in a cell and copied down as far as you
want, then copy the whole rangePaste SpecialValues.
--
Regards
Roger Govier
"MJ" wrote in message
...
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
|