Autofill outline numbering

[icius]

Hello all,

I would like the following kind of numbering:

4.1
4.2
4.3
4.4
4.5
4.6.
4.7
4.8
4.9
4.10
4.11
4.12
etc.

I would like to be able to put in 4.1 and then drag/autofill down to as
far as I need to go. Naturally Excel is treating this like a decimal
and after 4.9 it goes to 5.0 which is not what I want. What I am
trying to convey is that these rows are in "Section 4". It would also
be great if when I inserted a new row in the middle that all subsequent
rows were renumbered correctly. Can anyone think of a formula or way
to do this?

 

[nstrom]

I would like to be able to put in 4.1 and then drag/autofill down to as
far as I need to go. Naturally Excel is treating this like a decimal
and after 4.9 it goes to 5.0 which is not what I want. What I am
trying to convey is that these rows are in "Section 4". It would also
be great if when I inserted a new row in the middle that all subsequent
rows were renumbered correctly. Can anyone think of a formula or way
to do this?

How about (in cell A1)

="4." & ROW(A1)

then fill down.

 

[Gord Dibben]

Enter the 4.1 as text by prefacing with an apostrophe.

Drag/copy down.

Note: at 4.99 it changes to 4.100, not 5.0


Gord Dibben MS Excel MVP