Hi!
You could set up a custom list using:
Tools > Options > Custom Lists
Type in the Roman numeral series.
Or you could use Analysis ToolPak's ROMAN function:
=ROMAN(ROW(E3)-ROW($E$2))
Copy down
Here, I've used the cell the formula is entered into as E3 with the
second reference being an absolute reference to the cell above. If you
are starting in Row 1 just use =ROMAN(ROW(E1))
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
