Arte SheetsLearn. Try. Understand.

Math

ARABIC function: convert Roman numeral strings like MCMXCIV to numbers

Parse classic and subtractive Roman numeral strings into standard integers from 0 to 3999 using ARABIC.

Open spreadsheet ↗

Parse Roman numerals in legal, outline, and archival tables

ARABIC(text) converts Roman numeral strings such as "MMXXVI" (2026) or "MCMXCIV" (1994) into standard numbers, while ROMAN(number) performs the inverse conversion for integers 1 through 3999.

An empty string in ARABIC("") returns 0, whereas unrecognized characters return #VALUE!.

=ARABIC(A2)

Round-trip verification with ROMAN

Convert parsed integers back with ROMAN to confirm canonical subtractive notation.

=ROMAN(ARABIC(A2))

Try the example

Use the original values or change them to test your understanding.