How can I get Excel to AutoFill a pattern as follows (including the leading zero if needed):
010001
011001
012001
020001
021001
022001
...
990001
991001
992001
I can't get Excel to respect the leading zero or detect this pattern.
Is there a trick to it?
Best Answer
Assuming that you start in row 1, type in the following formula: