Autonumbering updates

  • Thread starter Thread starter Tom Bock
  • Start date Start date
T

Tom Bock

I am in need to replicate an MS-Word "Outline" structure in MS-Excel.

The below is a sample structure that I need to create and be able to
automatically update.

1
1.1.
1.1.1
1.1.2
1.2
1.2.1
1.2.2
2
2.1.
2.1.1
2.1.2
2.1.3
2.2
2.2.1
2.2.2
2.2.3

Essentially, I need to be able to INSERT rows -- let's say between 2.1.2 &
2.1.3. If done, I will create a "new" 2.1.3 task and automatically update
the existing 2.1.3. to 2.1.4.

My challenge is that I don't know how to overcome the limitation of "single
period" for data types that are number. As of now, these values are of
text type which will allow me to enter any character like multipe "dots".

At the same time, I cannot do any calculation to a text type.

Does anyone know of a workaround or nice solution in Excel?

Thanks,
Tom
 
Tom,

I think you'll have to put such multiple-period data as text, not a number.
Format the cell first (Format - Cells - Number - Text), or precede the entry
with an apostrophe. With either, using the fill handle will yield 1.1.2,
1.1.3, etc.

Earl Kiosterud
mvpearl omitthisword at verizon period net
 
Earl:

Yes, as mentioned in my thread, the data type is currrently set to "text".

Hmh, not sure what you mean by "fill handle". Whatever this feature is,
are you suggesting that it will automatically update e.g. "1.1.4" to "1.1.5"
after inserting a row?

Tom
 
Back
Top