The table below lists available Roman numbers with their equivalent Arabic number value.
Number must be positive and less than the value 3999.
The ROMAN function does the opposite of the ARABIC function
The form argument controls whether the roman numeral is abbreviated or not. The argument is optional and the default is zero (classic non-abbreviated). The ROMAN function supports additional forms 1-4 which are progressively more concise.
The Excel ARABIC function converts a Roman numeral, as text, to a number in Arabic numeral. For example, the formula =ARABIC("VII") returns 7.
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.