Convert roman numerals with Excel

This article will show you how easy it is to convert number in roman number, or the other way round, 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 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 for it's 5 minus 1 and in roman numeral it's IV

Other examples of subtractive notation

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

Use of roman numerals

Roman numerals are still use in certains situation

  • In books for the chapter numerals
  • Year of the production of a movie or TV report
  • Commemorative inscription, like on the book of the Statue of Liberty
  • Import text, like constitution

 

Convert number 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 use for the roman numerals is "Georgia"

Convert roman numerals to number

Since Excel 2013, you can also convert a roman numerals to number 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.