Roman Numerals

N

Norman Harker

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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top