ARABIC takes just one argument, roman_text, which should be a Roman number provided as a text string. For example, the formula below converts “VII” to the number 7:

Other examples

The ROMAN function performs the opposite conversion:

Roman numbers

The table below lists available Roman numbers with their equivalent Arabic number value.


The maximum length of roman_text is 255 characters. The ARABIC function performs the opposite conversion as the ROMAN function. If roman_text is not recognized as a Roman number, ARABIC returns #VALUE! ARABIC can process Roman numbers in upper or lower case.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.