Convert roman numerals with Excel

This article will show you how easy it is to convert numbers to roman numerals, or vice versa, with Excel.

Roman numerals

Roman numerals are represented by combinations of letters

  • I = 1
  • V = 5
  • X = 10
  • L = 50
  • C = 100
  • D = 500
  • M = 1000

To create a number, you just have write as many letters corresponding to the value you want to express

  • 3 = III
  • 25 = XXV
  • 178 = CLXXVIII

There is a specific notation to use when you reach a new level.

For instance of 4, you can write IIII but it's confusing with III. So the best way to represent it is as 5 minus 1, which roman numerals is IV

Other examples of subtractive notation:

  • 9 = IX
  • 40 = XL
  • 90 = XC
  • 99 = XCIX

Use of roman numerals

Roman numerals are still use in certain situations:

  • Chapter Numbers in books
  • Production Year of a movie or television documentary
  • Commemorative Inscription, for example, on the book that the Statue of Liberty is holding
  • Important Texts, like the constitution

Convert numbers to roman numerals

With Excel, it's very easy to convert any number to its roman numerals with the function ROMAN

=ROMAN(Number)

The font used for the roman numerals is "Georgia"

Convert roman numerals to numbers

Since Excel 2013, you can also convert a roman numerals to numbers with the function ARABIC

=ARABIC(Roman numerals)

Permanent link to this article: https://www.excel-exercise.com/convert-roman-numerals-with-excel/


Leave a Reply

Your email address will not be published.