ARABIC function
ARABIC converts a Roman numeral into a regular number. It is useful when cleaning data such as chapter labels or copyright-year labels, and invalid numerals return #VALUE!.
Example
Read it as a sentence: turn the Roman numeral MCMXCIV into an ordinary number, which gives 1994.
A
B
C
D
1
1994
2
3
Syntax
ARABIC(text)
-
text(required) - A Roman numeral as text, such as "XIV". Case does not matter.
Returns: The matching ordinary number.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=ARABIC("MCMXCIV") | 1994 | "MCMXCIV" |
=ARABIC("xiv") | 14 | Lowercase "xiv" |
=ARABIC("-X") | -10 | Negative "-X" |
=ARABIC("IIII") | 4 | Non-canonical "IIII" |
=ARABIC("IM") | 999 | "IM" |
=ARABIC("") | 0 | Empty string |
=ARABIC(0.5) | #VALUE! | Positive |
=ARABIC(0) | #VALUE! | Zero |
Watch out for
- Invalid numerals return #VALUE!.
- An empty string gives 0.
Where it works
- Excel
- ARABIC arrived in Excel 2013. Older versions do not have it.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Math and trig functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .