Hi,

Am Wed, 12 Feb 2014 10:56:18 -0800 (PST) schrieb :

I am starting at 00003600A, and when I put in =TEXT(ROW(A3600),"00000000A") it is just entered into the cell as text.

format your cells as General. If it doesn't work at once select the
column and run TextToColumns = Fixed width = Finish


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