How to generate sequential intervals from whole number

Is there a way to create Sequential intervals from a whole number?

for instance:

Cell B1 contains 5
I would like Cell C1 to show 1,2,3,4,5 or 1-5

Thank you.

Hi

Nothing is springing to my mind to generate the whole series. Simply generating "1-5" is easy enough:

="1-"&TEXT(B1,"#,###")

This will display 1-5 in the cell the above formula resides in. As you change the number in B1, the formula will update.

Hope that helps.