 Home » Text functions » Convert Roman Numbers with Excel

# Convert Roman Numbers with Excel

Last Updated on 15/05/2023 by Frédéric LE GUEN

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

## Roman numbers

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

# Convert Roman Numbers with Excel

Last Updated on 15/05/2023 by Frédéric LE GUEN

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

## Roman numbers

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