Home

Microsoft Excel [email protected]

Microsoft Excel 2007

Microsoft Excel 2003

Forums

Microsoft Excel 2003 Functions and Formulas

Using Excel to Convert to Roman Numerals

Summary: Need to convert MM to 2000? Use this Excel function.

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

Add: Del.icio.us | Digg | Furl | My Yahoo!

Last Modified on: July 13, 2008, at 12:04 A.M. EDT

Return to the Microsoft Excel 2003 Functions and Formulas page.

Print this tip.

- Subscribe!

Search the Site: