This tip was printed from the MalekTips Computer and Technology Help and Tips website at http://malektips.com.

Microsoft Excel 2003 Functions and Formulas - Using Excel to Convert to Roman Numerals

If you need to calculate a Roman numeral equivalent for a number, you can use Microsoft Excel 2003 to do the work for you:

=roman(NUMBER,FORM)

NUMBER is the number you want to convert

FORM is the type of Roman numeral you want. For most purposes, you can leave this blank, which will give you the classic form of Roman numeral. If you want to have a more simplified form, use a number from 1 to 4 here; as the number increases, it becomes more simplified, with 4 converting the number into its simplest form.

Examples:

=roman(1999,0)

MCMXCIX

=roman(1999,1)

MLMVLIV

=roman(1999,2)

MXMIX

=roman(1999,3)

MVMIV

=roman(1999,4)

MIM

=roman(2006,0)

MMVI