Announcement: THIS PROBLEM HAS BEEN SOLVED. Thanks everyone who have spent time on my problem. But if anyone like to participate feel free to put your solutions here. There are many ways for doing things, and certainly, each journey to find the answer is more beautiful than the answer itself...
Hey Bosco, Thanks for your input. This is another great idea! Sometimes if the spreadsheet does not start from Row 1, if the cell is A20, the formula becomes =A$20&"."&ROW(A1). when a row is added, the formula need to drag down to the end. Excellent simple solution, thanks Bosco. :cool:
Your solution is the best so far. It not only shows 5, 5.1, 5.2.. also does 5.1, 5.1.1, 5.1.2,....and when I add a row between, I only need to do drag another 2 cells to make all the changes. Once the formula is working, it can copy all over the place in the same row as long as it's in A row...
Hey Vletm, thanks for your contribution. Really appreciate. It might be some small bugs there stopping it doing number starting with 2 or 3....I found an alternative solution below from Haz, and thanks again.
Thanks Alan, that's a smart shortcut. really appreciate that just haven't thought about it. :)
But if anyone still can work on this problem I will be still curious to know, as I am basically working on Excel as a word and all those prefilled forms has numbering like book chapters and sections...
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...