ARABIC in Excel: Convert Roman Numerals into Usable Numbers
Convert Roman text with Excel ARABIC, preserve source labels, handle empty and invalid inputs, and sort numbered sections numerically.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: ARABIC converts Roman-numeral text into a number. For example, =ARABIC("XLIV") has the expected result 44, which can participate in arithmetic or numerical sorting.
Availability and version history
- Introduced: Marked as an Excel 2013 addition in the Microsoft function catalogue; an exact first build is not established.
- Availability: official help lists Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016.
- Checked: October 14, 2026; official ARABIC reference. Examples are independently calculated expectations, not native Excel test results.
Syntax and input rules
=ARABIC(text)
Supply a quoted Roman numeral or a cell holding that text. A plain number or date is not a Roman-text input. Microsoft documents #VALUE! for invalid values, including those input types and text it cannot interpret as a Roman numeral. Its dedicated reference also documents case-insensitive conversion, ignored outside spaces and a 255-character input limit.
This is conversion, not a rule enforcing a particular historical style of Roman notation. Excel accepts a leading negative sign and maps an empty string to zero, so a successful conversion alone cannot prove that a label satisfies your editorial policy.
Prepare section labels
Enter this small fictional contents list in A1:B5. Enter the labels in column A as text; the headings occupy row 1.
| A: Section | B: Pages |
|---|---|
| IX | 6 |
| IV | 3 |
| XII | 8 |
| VII | 5 |
In C1 enter Numeric section. In C2 enter =ARABIC(A2) and fill down through C5. Expected C2:C5: 9, 4, 12, 7.
Keep column A rather than replacing it. That preserves the exact source label for display and lets you investigate a conversion error without reconstructing the original text.
Example 1: verify place and subtractive notation
=ARABIC("XLIV")
=ARABIC("XCIX")
=ARABIC("MMXXVI")
Expected results: 44, 99, 2026. XL contributes 40 and IV contributes 4. XC contributes 90 and IX contributes 9. The last label combines 2000, 20 and 6.
These examples contain ordinary canonical forms. Do not extend a few successful cases into a claim that the function rejects every unusual Roman spelling.
Example 2: case, outside spaces and signed text
=ARABIC(" xiv ")
=ARABIC("-XLII")
Expected results: 14 and −42. The first result follows the documented case and outside-space handling. The second uses Excel’s supported negative-prefix convention, even though negative Roman numerals are nonstandard.
This does not establish that embedded spaces, punctuation or every Unicode Roman-numeral glyph is accepted. Preserve unfamiliar inputs for review rather than silently removing arbitrary characters.
Example 3: distinguish an empty label from zero
=ARABIC("")
Expected result: 0. If zero is not a valid section number, test for missing input before conversion. For a text label in A2:
=IF(A2="","Missing label",IFERROR(ARABIC(A2),"Review label"))
With A2 set to IV, the expected result is 4. With an empty A2 it is Missing label. With Appendix, it is Review label. The IFERROR wrapper catches all errors from its conversion expression, so retain the raw source alongside the status.
The initial test deliberately checks an empty value. A label consisting only of whitespace requires a separately defined cleaning rule; it is not covered by that comparison.
Advanced example: numerical ordering without losing labels
Sort the entire A2:C5 table by C ascending, keeping all three columns together. The expected section order is IV, VII, IX, XII, with page counts 3, 5, 6, 8.
Sorting column A alphabetically asks a different question. Converting to a numeric helper column makes the intended ordering explicit, while sorting the complete rectangle keeps each page count attached to its section.
The page total remains =SUM(B2:B5), expected 22, before or after sorting. This independent total is a useful check that sorting moved records rather than dropping them.
Advanced example: calculate a gap between labels
For a first section label VII in E2 and last label XII in F2:
=ARABIC(F2)-ARABIC(E2)+1
Expected result: 6. This is the count of consecutive integers from 7 through 12, including both endpoints. It does not prove that every section in that interval exists in your document; compare against the actual contents list when gaps matter.
Limits and troubleshooting
Do not remove the quotation marks from a literal Roman numeral: without them Excel treats a token as a name or reference. Use normal straight formula quotes when copying examples.
The 255-character limit is a text-length constraint; it is not the same as a conventional upper bound on Roman notation. Microsoft documents a maximum returned value of 255,000. Extremely long labels are unlikely to be suitable section identifiers even when conversion is possible.
If every result is an error, check whether the inputs are genuine Roman text, whether your Excel release supports the function and whether an import substituted look-alike characters. Keep conversion and validation as separate, visible steps.
Verification: Fictional inputs and independently calculated outputs; no native Excel execution. See the editorial testing standards.