#### Jimmy QU

##### New Member

Hi All,

I just had this issue I cannot find the best way to do it and you might already have the solution. Basically I need a formula that can do this.

5

5.1

5.2

5.3

....

5.9

5.10

5.11

5.12

...

5.99

5.100

...

5.xxxxxxxx

After I type 5 and 5.1 it would be able to drag all the way as the list goes. (Optional function) When I delete one of them, the series number below will be automatically adjust the numbers, no matter if i move up the cell below or not.

Basically it's a word function in excel, the number shows the level of titles.

Could someone help me please? Thank you.

I have attempted but failed, the challenge is that it's not a number increase as the next one after 5.9 becomes 6. Also I could not do a combination of joining a formula with numbering and text start at 5 at the same time. And I don't have a space to put a numbering bar in the spreadsheet just to combine the text. Also as you can see it's not a number, as 5.10 will be displayed as 5.1.

Thanks again for your time.

I just had this issue I cannot find the best way to do it and you might already have the solution. Basically I need a formula that can do this.

5

5.1

5.2

5.3

....

5.9

5.10

5.11

5.12

...

5.99

5.100

...

5.xxxxxxxx

After I type 5 and 5.1 it would be able to drag all the way as the list goes. (Optional function) When I delete one of them, the series number below will be automatically adjust the numbers, no matter if i move up the cell below or not.

Basically it's a word function in excel, the number shows the level of titles.

Could someone help me please? Thank you.

I have attempted but failed, the challenge is that it's not a number increase as the next one after 5.9 becomes 6. Also I could not do a combination of joining a formula with numbering and text start at 5 at the same time. And I don't have a space to put a numbering bar in the spreadsheet just to combine the text. Also as you can see it's not a number, as 5.10 will be displayed as 5.1.

Thanks again for your time.

Last edited: