ARABIC Function
Converts Roman numerals to a number.
Category
Math & Trig
Available in
Excel 2013+, Microsoft 365
Returns
A number
Want to practice ARABIC in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
ARABIC is the reverse of ROMAN: "MMXXVI" becomes 2026.
Handy when chapter or clause numbers arrive as Roman numerals and need sorting.
Syntax
=ARABIC(text) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| text | Yes | Roman numerals as text. |
Examples
Example 1 — Sorting clauses
Convert clause numbers so they sort correctly.
B2fx=ARABIC(A2)
| A | B | |
|---|---|---|
| 1 | Clause | Number |
| 2 | XIV | 14 |
| 3 | IX | 9 |
| 4 | MMXXVI | 2026 |
=ARABIC(A2) Explain
Common mistakes
- Invalid characters. Letters that aren't Roman numerals return #VALUE!.
Notes
- Not case-sensitive.
- Related functions: ROMAN.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.