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: