You could put this in a cell in row 1 and drag down as far as you needed:

=TEXT(1+(INT((ROW()-1)/6)),"0000")



BattyKat wrote:

I am creating a file to print on some cards. The same number has to repeat 6
times and then be in sequential order. Because I have '0001 , I can not do
any of the quick fill options because of the '.
For ex.
'0001
'0001
'0001
'0001
'0001
'0001
'0002
'0002
ETC....

I need to number to 357-- is there an easy way to do this ? I need to have
4 positions on my printed sheet because its a parking pass and the vendor
requires the numbers to match their lot numbers.

--

Dave Peterson