Custom format number and date together

Try this formula somewhere in row 1 copied down

=TEXT(ROW(),"0000""-07""")

you can convert to values after, if you wish, by using copy and then edit > paste special > values

Thank you for that formula -- it really helped me out.

THANKS!