Exceljet

Quick, clean, and to the point

Excel ARABIC Function

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.
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