Excel functions / Math

ROMAN function

Writes a number in Roman numerals.

Syntax

=ROMAN(number, [form])

Arguments

When to use it

ROMAN writes a number from 1 to 3999 in Roman numerals, as text. ARABIC reads them back.

Examples

  1. A year

    ABC
    1Year
    22026MMXXVI

    In C2: =ROMAN(A2) → MMXXVI

    Try this example

  2. A chapter number

    ABC
    1Chapter
    214Chapter XIV

    In C2: ="Chapter " & ROMAN(A2) → Chapter XIV

    Try this example

Common mistakes

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.

Translate a whole formula

Try ROMAN in the playground

Related functions