This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.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



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Functions and Formulas - Using Excel to Convert to Roman Numerals.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.