formating incrementing numbers

[Bert]

It almost seems silly asking this question, but I can't figure out how to do
this.
I need to come up with a grid 4 cells X 100 cells each cell containing
numbers in the following format.
A B C D
1 06-001 06-002 06-003 06-004
2 06-005 06-006 06-007 06-008
all the way up to ...
100 06-397 06-398 06-399 06-400
(Or however the lost rows work out)

I'm trying formulas, but no either I loose the two leading zeros in the
second part of the number, or get some kind of error message.

Thanks.
Bert.

 

[Pete_UK]

Enter the number 6001 in A1, then use Format | Cells on this cell,
giving it a Custom format of 00-000. Then in B1 enter the formula:

=A1+1

and the format should be the same. Copy B1 to C11. Enter this formula
in A2:

=A1+4

and again the format should follow it. Copy B11 into B22. Then
highlight A22 and copy these cells down into A3:A100, and you should
have what you want.

Hope this helps.

Pete

 

[Dave Peterson]

Put this in A1:
="06-"&TEXT((4*(ROW()-1))+COLUMN(),"000")
Drag to the right (to D1)
and select those four cells (a1:d1) and drag down to row 100.

 

[Pete_UK]

You're welcome, Bert - thanks for the feedback.

Pete