Autofill using formula

[Damaris500]

Hi! How can I automatically fill the cells using a formula so it can give me continuous numbers? Ex. *100-01* for it to continue with 02,03,04,05 exc.

[#2]

Hello @Damaris500,

I do not know for sure if I got your question correctly. Try the following:

=TO.COL(SEQUENCE(1,2,100,1)&"-"&TEXT(SEQUENCE(99,1,1,1),"00"),,1)

If it is not what you required, let me know. I also attach sample file with the formula itself. It is a dynamic array formula so you won't be ale to use it inside of an Excel table. It is one downside of this solution.