Excel functions / Math

ARABIC function

Turns Roman numerals into a number.

Syntax

=ARABIC(text)

Arguments

When to use it

ARABIC turns Roman numerals into an ordinary number, so they can be sorted or calculated with. It is the inverse of ROMAN.

Examples

  1. A year in Roman numerals

    ABC
    1Numerals
    2MCMXCIV1994

    In C2: =ARABIC(A2) → 1994

    Try this example

  2. Years since

    ABC
    1Numerals
    2MCMXCIV32

    In C2: =2026-ARABIC(A2) → 32

    Try this example

Common mistakes

ARABIC 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 ARABIC in the playground

Related functions