ive got a huge excel workbook that needs to change. in the first column there is what amounts to a numbered list. and, using excels number formatting options, it used to behave nicely. at least, the people that had it before me said that it worked properly. all of the numbers have since been changed.
the previous format was like this

1
1.1
1.2
1.2.1
1.2.2
1.2.3
1.3

they wanted to change all of the numbers to two digits, so now it looks like this

01
01.01
01.02
01.02.01
01.02.02
01.02.03
01.03

what is supposed to happen is this
if a new row is added, it should fill in that cell with the appropriately labeled number that is next in the sequence directly above it. if the number is changed it should change the whole numbering accordingly
initial

01
01.01
01.02
01.02.01
01.02.02

then we insert a row in between '01.02.01' and '01.02.02', this new row should have the first cell as '01.02.02' and change the one below it to '01.02.03'

01
01.01
01.02
01.02.01
01.02.02 <--new row
01.02.03

now, if we were to change the new cell from '01.02.02' to '01.03' the very next cell should change to '01.03.01'

01
01.01
01.02
01.02.01
01.03
01.03.01

it seems to me like there should already be a feature that exists that does this. i cant seem to figure it out, but then, this is my first time ever trying to play with excel. if i could paste these spreadsheets into word and have it number them properly, i would do so. but word doesnt recognize them as an already existing numbered list. which is a huge pita.

any suggestions at all?