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

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.