Auto fill sequence

[trakai]

Hey folks!

I am fighting with this for a longer time now and can't find a solution:
is it possible in Excel to generate a number sequence (to create a list for auto fill) representing numbers like this:

000001
000006
000002
000007
000003
000008
000004
000009
000005
000010
000011
000016
000012
000017
000013
000018
000014
000019
000015
000020


and so on till 001000

Thank you in advance.

[oldchippy]

Select your cell A1, Format > Custom and enter in the box 000000 (six zero's)

Then enter 1 in A1 the result will be 000001, now you can use auto-fill

[trakai]

Thank you. This is something I did not know either, though the question
is still open - is it possible to create such a list for auto fill, where the sequence of numbers goes like in the example above?

[oldchippy]

OK, try something like this, format columns A, B and C as before, then in A1 type 1, A3 type 2, select A1:A4 and auto-fill down.

Select B2, type 6, select B4 type 7, select B2:B5, auto-fill down.

In C1 type this formula and auto-fill down

=IF(A1="",B1,A1)

[trakai]

Grand. fill down for column A and B works great.
Problem occured with the formula:
=IF(A1="",B1,A1)
Excel screams that the formula contains an error.

so I played with it a bit and changed it's commas with semicolons
=IF(A1="";B1;A1)

It does not complain about any errors anymore though the results after fill down do contain some data I don't need in there.

I attached the resulting excel file to this post. I filled the blocks of correct data with green and the wrong ones with red.

What I am doing wrong?

[oldchippy]

File not attached? - Got it now