Formatting cells with numbers

[Vanessa]

I am wondering if there is anyway in excel to format
cells with numbers in order in a column. For example:

12345 in the top row
12346 in the second row
12347 in the third

and so on... I know this is expecting a whole lot, but I
need soemthing like that.

Thanks,
Vanessa

 

[ElsiePOA]

One way -
In cell A1, enter 12345
In cell A2, enter =A1+1
then copy cell A2 down as many cells as you wnt numbers in.

If after doing this, you want to convert the cells from formulas t
actual numbers, highlight the cells, select COPY and then select PAST
SPECIAL and choose value

 

[Vanessa]

Thank you so much for the help... does this also work
with dates when I want to date something like for the
whole month?

 

[Gord Dibben]

Vanessa

Alternative that doesn't involve formulas.

Enter 12345 in A1.

Right-click on bottom right corner of A1 and drag down or across as far as you
wish.

Release the mouse button and select "Fill series" from the choices.

You can do the same for dates.

Enter the date in A1 and right-click drag.

NOTE: you must have Tools>Otions>Edit. "allow cell drag and drop" enabled.

Gord Dibben Excel MVP