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