ARABIC

ARABIC is the inverse of ROMAN: it takes a Roman numeral string (e.g. "XIV") and returns the corresponding Arabic integer (14). It handles both uppercase and lowercase input and accepts up to 255 characters.

Excel

=ARABIC(A2)

Google Sheets

=ARABIC(A2)

✓

Verified example

Computed by a real spreadsheet engine on the sample data below.

Roman	Arabic
XIV
XL
MMXXIV
IX

=ARABIC(A2)→14

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Cell row 1 column 1	Cell row 1 column 2
Cell row 2 column 1	Cell row 2 column 2
Cell row 3 column 1	Cell row 3 column 2
Cell row 4 column 1	Cell row 4 column 2
Cell row 5 column 1	Cell row 5 column 2

Formula

Runs server-side · free · no signup

How it works

1A2 is a text cell containing a Roman numeral string such as "XIV" or "mmxxiv".
2ARABIC parses the string and returns the integer equivalent.
3ARABIC("MMXXIV") returns 2024.

Need a version for your data?

Try: “Convert a column of Roman numerals back to regular numbers”

SUMIF SUMIFS COUNTIF

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026

ARABIC

Verified example

Try it with your data

How it works

Related