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
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