Hi,

Am Wed, 12 Feb 2014 10:28:21 -0800 (PST) schrieb :

I am trying to make a list of numbers plus a letter:
00000001A
00000002A
00000003A

in A1 try:
=TEXT(ROW(A1),"00000000")&"A"
and copy down


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2