How to Convert Roman Numerals in Excel (Both Ways)
Chapter and clause numbering, monarchs and popes, event titles, and the Olympiad-style numbering sports bodies insist on. Excel has ROMAN() and ARABIC() — one cell at a time, in a formula column you then have to convert to values.
Last updated: October 2026
| Number | → | Roman |
|---|---|---|
| 1987 | → | MCMLXXXVII |
| 4 | → | IV |
| 2026 | → | MMXXVI |
Strict on the way back
Going from numerals to numbers, this accepts only well-formed numerals — ones that convert back to exactly what you typed. IIII and IC are rejected rather than quietly read as 4 and 99, because a lenient parser turns malformed input into a number nobody wrote, and you would never see it happen.
The range it can express
1 to 3,999 — the span classical notation covers without the overbar used for larger values. Anything outside it, and anything that is not a whole number, is reported rather than approximated.
The 1-click way (Tellsheet)
Roman Numerals
Select the range and run Roman Numerals, choosing which way to convert. Everything converts in place, blanks stay blank, and anything that cannot be converted is either kept as it was or cleared — your choice — and counted in the summary, so a column of mixed content never silently loses a value.
Frequently asked questions
Doesn't Excel have ROMAN()?
Yes, per cell in a formula. This does the range and writes values.
What range is supported?
1 to 3,999, the classical range.
Is IIII accepted?
No — malformed numerals are rejected rather than guessed at.
What happens to text in the range?
It is kept and counted, or cleared if you prefer.
Related Excel guides
A range at a time, not a cell
Roman Numerals converts both ways and reports what it could not take.
Get Tellsheet free See pricing