Solved: SPECIAL NUMBERING

[GaryB]

Hi All,

This one has me a loss. I have a request to see if there is a way to automate some special number that will be used as variable data in a print file. What they want is a sequence like this:

1-1
1-2
1-3
1-4
1-5
2-1
2-2
2-3
2-4
2-5

and so on so that is automatically changes when they put a total number needed. I hope I am explaining this correctly.

Thanks for any help with this.

Gary

[GaryB]

Please let me change this? In format cells - custom- I created a special format of 0"-"0 This has allowed me to enter a number, say 11 and it show in the cell as 1-1 in the next cell down if I enter 12 it shows as 1-2. When I select both cells and drag them down the column it shows 1-1 through 1-9 and then changes to 2-0 through 2-9 then changes to 3-0 etc.... What I need to do is have the changes occur evey 5 numbers instead of 10 and to eliminate the -0 from coming up at all. Any ideas? Please?

[p45cal]

Stick with your format, seed say A2 with a starting number, then in cell A3:
=IF(MOD(A2,5)=0,A2+6,A2+1)
and drag down. Then Copy paste-values over the top.

[GaryB]

P45 You totally Rock! That did the trick. Thank you so much for taking the time.

Gary:friends: