Convert Roman Numbers with Excel

Convert Roman Numbers with Excel
Last Updated on 18/04/2024
Reading time: 2 minutes

This article will show how easy it is to convert numbers to Roman numbers with Excel.

What are 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 to 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 numeral is IV

Other examples of subtractive notation:

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

Use of Roman numbers

Roman numerals are still used in certain situations:

  • Chapter Numbers in Books
  • Year of a movie or television documentary
  • Commemorative Inscriptions, for example, the Statue of Liberty's book
  • Important Texts, like the constitution

Convert numbers to Roman numbers

With Excel, it's effortless 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 Roman numerals to numbers with the ARABIC function

=ARABIC(Roman numerals)

1 Comment

  1. angus
    15/02/2022 @ 00:56

    Very cool thanks for the help poggers

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Convert Roman Numbers with Excel

Reading time: 2 minutes
Last Updated on 18/04/2024

This article will show how easy it is to convert numbers to Roman numbers with Excel.

What are 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 to 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 numeral is IV

Other examples of subtractive notation:

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

Use of Roman numbers

Roman numerals are still used in certain situations:

  • Chapter Numbers in Books
  • Year of a movie or television documentary
  • Commemorative Inscriptions, for example, the Statue of Liberty's book
  • Important Texts, like the constitution

Convert numbers to Roman numbers

With Excel, it's effortless 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 Roman numerals to numbers with the ARABIC function

=ARABIC(Roman numerals)

1 Comment

  1. angus
    15/02/2022 @ 00:56

    Very cool thanks for the help poggers

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *