How to increase number sequence for special cases?

[hbster]

I will like to increase this type of number sequence:

01-01
02-01
03-01
04-01

or

01-02
01-03
01-04
01-05

Any experts can help on this?

[Phuocam]

Try this ...

=TEXT(ROWS($A$1:A1),"00")&"-01"

or:

="01-"&TEXT(ROWS($A$1:A1),"00")

[hbster]

Try this ...

=TEXT(ROWS($A$1:A1),"00")&"-01"

or:

="01-"&TEXT(ROWS($A$1:A1),"00")

Thanks for the help and I had tried it... however seems like its working for Rows only?

how about column based?


For example

A1,ROW1 : 09-01
A1,ROW2 : 10-01 (<- shall i input the formula here?)

[bebo021999]

Try:

=TEXT(9+ROW(1:1)-1,"00")&"-01"
if you want to start from 09-01 then 10-01 ...

Or:
="01-"&TEXT(9+ROW(1:1)-1,"00")
if you want to start from 01-09 then 01-10 ...