TEXT DATE YEAR TODAY SEQUENCE 161mmm. Excel has a great built-in tool for creating number series named Autofill. Select the cells that contain the starting values.
Build a regular SEQUENCE formula and warp it in the ROMAN function.
Select the range of cells you want to add leading zeros to and open up the Format Cells dialog box. Build a regular SEQUENCE formula and warp it in the ROMAN function. Type 1 into a cell that you want to start the numbering then drag the autofill handle at the right-down corner of the cell to the cells you want to number and click the fill options to expand the option and check Fill Series then the cells are numbered. Create a sequence of Roman numbers.