|
| 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!
 Discuss This Tip
 Print This Tip
 Get E-Mail When New Tips are Online
Return to the Microsoft Excel 2003 Functions and Formulas page. |
