Excel functions / Math
ROMAN function
Writes a number in Roman numerals.
Syntax
=ROMAN(number, [form])
Arguments
number: A whole number from 0 to 3999.form(optional): Excel offers shorter forms (1 to 4); only the classic form, 0, is supported here.
When to use it
ROMAN writes a number from 1 to 3999 in Roman numerals, as text. ARABIC reads them back.
Examples
A year
A B C 1 Year 2 2026 MMXXVI In C2:
=ROMAN(A2)→ MMXXVIA chapter number
A B C 1 Chapter 2 14 Chapter XIV In C2:
="Chapter " & ROMAN(A2)→ Chapter XIV
Common mistakes
- Out of range. Numbers below 1 or above 3999 give #VALUE!.
ROMAN in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: ROMAN
- Danish: ROMERTAL
- Dutch: ROMEINS
- Finnish: ROMAN
- French: ROMAIN
- German: RÖMISCH
- Hungarian: RÓMAI
- Italian: ROMANO
- Norwegian: ROMERTALL
- Polish: RZYMSKIE
- Portuguese (Brazil): ROMANO
- Portuguese (Portugal): ROMANO
- Russian: РИМСКОЕ
- Spanish: NUMERO.ROMANO
- Swedish: ROMERSK
- Turkish: ROMEN