Excel ARABIC Function

Summary
The Excel ARABIC function converts a Roman numeral, as text, to a number in Arabic numeral. For example, the formula =ARABIC("VII") returns 7.
Purpose
Converts a Roman numerals to an Arabic numerals
Return value
A number (in Arabic numeral)
Syntax
=ARABIC (roman_text)
Arguments
- roman_text - The Roman numeral in text that you want to convert.
Version
Usage notes
The ARABIC function converts a Roman numeral to a number in Arabic numeral. For example, the formula below converts "V11" to 7:
=ARABIC("VII") // returns 7
Roman numbers
The table below lists available Roman numbers with their equivalent Arabic number value.
Symbol | Value |
---|---|
I | 1 |
V | 5 |
X | 10 |
L | 50 |
C | 100 |
D | 500 |
M | 1000 |
Notes
- The maximum length of roman_text is 255 characters.
- ARABIC function does the opposite of the ROMAN function
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.